Custom Month to date

[greggue]

Hello all,

Our fiscal months are not based on calendar months but ends on the Saturday of every month.  Therefore the our fiscal month starts on different day every month.
I have the dax formula to calculate the last saturday of the month but I am not sure how to implement it to use in my slicer

Here's the measure that give me the last saturday of the month

customEOM =

VAR dateVal = [Date]

RETURN

    if (

        dateVal > DATE ( '2018, 12, 31'),

        if (

            dateVal

                > if (

                    WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) = 7,

                    EOMONTH ( dateVal, 0 ),

                    EOMONTH ( dateVal, 0 ) - WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 )

                ),

            if (

                WEEKDAY ( EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), 1 ) = 7,

                EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ),

                EOMONTH ( EOMONTH ( dateVal, 0 ), 1 )

                    - WEEKDAY ( EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), 1 )

            ),

            if (

                WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) = 7,

                EOMONTH ( dateVal, 0 ),

                EOMONTH ( dateVal, 0 ) - WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 )

            )

        ),

        EOMONTH ( dateVal, 0 )

    )

[andhiii079845]

What is if you create a custom table for your date where you can descripe which date is in which fiscal month.

That make it more easier I think.