Forum Discussion

fareedice's avatar
fareedice
Frequent Visitor
3 years ago

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.....
Need Help
fareedice's avatar
fareedice
Frequent Visitor
3 years ago

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..

RobertPaegelow's avatar
RobertPaegelow
Icon for Helper I rankHelper I
3 years ago

Okay, that's weird. Could you send me the error message??

  • fareedice's avatar
    fareedice
    Frequent Visitor
    3 years ago