Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

View My Drafts

  • 1.  MTD - Custom Fiscal Month last Saturday of the month

    Posted 14 days ago

    Hi,

    the fiscal month in our company is a that ends on the last saturday of each month.

    It is not a standard calendar month.
    I am looking for a DAX formula that can do that calculation for a slicer.

    Any help or direction would be greatly appreciated.



    ------------------------------
    Gregory Gue
    Business Intelligence Analyst
    ------------------------------


  • 2.  RE: MTD - Custom Fiscal Month last Saturday of the month

    Posted 10 days ago
    Veja se ajuda

    srthr


    Calendar = 
ADDCOLUMNS (
    CALENDARAUTO (),
    "WeekDayName", FORMAT ( [Date], "dddd" ),
    "LastDateSaturday",
        MAXX (
            FILTER (
                CALENDARAUTO (),
                MONTH ( [Date] ) = MONTH ( EARLIER ( [Date] ) )
                    && WEEKDAY ( [Date] ) = 7
            ),
            [Date]
        )
)​


    ------------------------------
    Vilmar Santos
    ------------------------------

    Original Message


  • 3.  RE: MTD - Custom Fiscal Month last Saturday of the month

    Posted 10 days ago
    Thank you very much @Vilmar Santos and evryone who answered.
    This helps me a lot

    Gracias
    ​

    ------------------------------
    Gregory Gue
    Business Intelligence Analyst
    ------------------------------

    Original Message