Week End Date in DAX

[Anonymous]

Hi Power BI experts,

I am having some trouble creating week end date that ends on Friday and containes dates from last Saturday to Friday using Dax. For example, any dates from 07/11/2020 to 07/17/2020 should have week end date as 07/17/2020; any dates from 07/18/2020 to 07/24/2020 should have week end date as 07/24/2020,etc. I would really appreciate your help a lot because I have been stuck on this last several days.

[Greg_Deckler · Accepted solution]

@Anonymous - Try this out: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293#M120

[Anonymous]

@Greg_Deckler @Anonymous 

Thank you so much for both of your help!

[Anonymous · Accepted solution]

@Anonymous 

Not sure you want a column or measure, try both.

Column = CALCULATE(MIN([Date]),FILTER('Table',WEEKDAY([Date],2)=5 && [Date]>=EARLIER('Table'[Date])))

Measure = CALCULATE(MIN([Date]),FILTER(ALL('Table'),WEEKDAY([Date],2)=5 && [Date]>=MAX('Table'[Date])))

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@Anonymous - Try this out: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293#M120