Custom Month to date

Question

Hello all,Our fiscal months are not based on calendar months but ends on the Saturday of every month.&nbsp; 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&nbsp;&nbsp;Here's the measure that give me the last saturday of the monthcustomEOM =VAR dateVal = [Date]RETURN&nbsp; &nbsp; if (&nbsp; &nbsp; &nbsp; &nbsp; dateVal &gt; DATE ( '2018, 12, 31'),&nbsp; &nbsp; &nbsp; &nbsp; if (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dateVal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt; if (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) = 7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( dateVal, 0 ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( dateVal, 0 ) - WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WEEKDAY ( EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), 1 ) = 7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( EOMONTH ( dateVal, 0 ), 1 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; - WEEKDAY ( EOMONTH ( EOMONTH ( dateVal, 0 ), 1 ), 1 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 ) = 7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( dateVal, 0 ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( dateVal, 0 ) - WEEKDAY ( EOMONTH ( dateVal, 0 ), 1 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; EOMONTH ( dateVal, 0 )&nbsp; &nbsp; )&nbsp;&nbsp;

andhiii079845 · Answer

What is if you create a custom table for your date where you can descripe which date is in which&nbsp;fiscal month.That make it more easier I think.

Forum Discussion

Custom Month to date

1 Reply

Related content

Custom Date Slicers

convert date to month name

Previous month and Current month custom Date columns

Total Customers (end of month)

Custom Date Range Slicer