Forum Discussion
Dynamic weekend date
Hi I have date table with dates from Year 2021 to 2025. I want to create a dynamic measure, whenevr power BI report is opened by a user, then the date should display as last weekending date.....
Try this instead, Last Friday = CALCULATE( MAX([Date]), FILTER( ALL(Date), [Day of Week] = 6 ), [Date Filter] )
Thank you for the Reply...In this formula...Last Friday = CALCULATE( MAX([Date]), FILTER( ALL(Date), [Day of Week] = 6 ), [Date Filter] )
the last part [Date Filter] is showing error... Do I have to derive any column? sorry i did not get..
Okay, that's weird. Could you send me the error message??
