Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to limit my running total to today. My current formula is below; I've tried adding a filter to limit to todays date.
Solved! Go to Solution.
Hi @Jondon29
You mean you want to show the line only until today?
Assuming your measure works correctly, you can do something like:
NewMeasure = IF ( MAX ( '1 - DateTable'[Date] ) <= TODAY (), [YourWorkingMeasure] )
This returns a blank on dates after today, so that nothing will be displayed. You could also embed this behavior in your current measure.
Hi @Jondon29
You mean you want to show the line only until today?
Assuming your measure works correctly, you can do something like:
NewMeasure = IF ( MAX ( '1 - DateTable'[Date] ) <= TODAY (), [YourWorkingMeasure] )
This returns a blank on dates after today, so that nothing will be displayed. You could also embed this behavior in your current measure.
That worked perfect, thank you very much.
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |