Forum Discussion
Week End Date in DAX
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.
Anonymous - Try this out: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293#M120
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.
3 Replies
Greg_Deckler Anonymous
Thank you so much for both of your help!
- Greg_Deckler
Community Champion
Anonymous - Try this out: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293#M120
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.