Forum Discussion
Default visual selection on last week ending
Hello,
Trying to find the best way to have this as defaulted to the last week ending.
Eg,
Today is 4th of March. I would like the visual to filter on the group of records with week ending 3rd of March.
I already have a calculated column for Week Ending and my data is sorted accordingly.
Hi Anonymous
It seems you may create a measure with IF condition.For example:
Measure = IF ( MAX ( Table[Week Ending] ) <= TODAY (), CALCULATE ( SUM ( ... ) ) )
You may set the X-Axis as below.
Regards,
Cherie
2 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
It seems you may create a measure with IF condition.For example:
Measure = IF ( MAX ( Table[Week Ending] ) <= TODAY (), CALCULATE ( SUM ( ... ) ) )
You may set the X-Axis as below.
Regards,
Cherie