Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  MTD - Custom Fiscal Month last Saturday of the month

    Posted 11 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 8 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
    ------------------------------



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

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

    Gracias


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