Forum Discussion

frankGB's avatar
frankGB
Frequent Visitor
4 years ago

Dynamic DAX date table based on a reference date from a Filter

Hi,   I am trying to create a dynamic date table in DAX with calcualted dates based on a in a filter selected reference date.    Let's say the selected reference date in the filter visual is 15/0...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

frankGB , You have to create a measure and filter

 

calculate(sum(Table[Value]), filter(Table, Mod(Datediff(selectedvalue(Date[Date]), Date[Date], day),7) =0))

 

or

 

calculate(sum(Table[Value]), filter(Table, Mod(Datediff(selectedvalue(Date[Date]), Date[Date], day)+1,7) =0))