Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |