Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |