Find last Saturday of previous month and last friday of current month end in given Date table

kkanukurthi — Fri, 07 Jun 2024 13:48:27 GMT

Hi Anonymous ,

Thanks for the solution for my latest post .https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-last-Saturday-of-previous-month-and-last-friday-of-current/m-p/3958935

It works perfect for me. Above solution is for dates between CALENDAR("4/1/2024", "8/31/2024"). I mean it is comparing Month(Today()).

Can you please help me with Dax code for dates between 01/01/2023 to 31/12/2025. I need for past and future dates please.

What is the slight modification that I need to do in Dax code?

Thanks in Advance

Re: Find last Saturday of previous month and last friday of current month end in given Date table

Anonymous — Mon, 10 Jun 2024 09:02:11 GMT

Hi kkanukurthi ,

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the new column to find the last Friday current month.

last friday current month = CALCULATE( MAX('Table'[Date]), FILTER( 'Table', MONTH('Table'[Date]) = MONTH(EARLIER('Table'[Date])) && YEAR('Table'[Date]) = YEAR(EARLIER('Table'[Date])) && 'Table'[weekday] = 5 ) )

3.Create the new column to find the last Saturday previous month.

last saturday previous month = var last_mon = 'Table'[Date] var last_year = CALCULATE( MAX('Table'[Date]), FILTER( 'Table', MONTH('Table'[Date]) = MONTH(last_mon) - 1 && YEAR('Table'[Date]) = YEAR(last_mon) && 'Table'[weekday] = 6 ) ) var last_12 = CALCULATE( MAX('Table'[Date]), FILTER( 'Table', MONTH('Table'[Date]) = 12 && YEAR('Table'[Date]) = YEAR(last_mon) - 1 && 'Table'[weekday] = 6 ) ) RETURN IF(MONTH('Table'[Date]) = 1, last_12, last_year)

4.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Find last Saturday of previous month and last friday of current month end in given Date table in DAX Commands and Tips

Find last Saturday of previous month and last friday of current month end in given Date table

Re: Find last Saturday of previous month and last friday of current month end in given Date table