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 have a running total quick measure which is calculating a running total however there is no data after 45 days ago but the running total is still calculating a flat line up to today.
How do I stop the running total 45 days ago instead of running to today please?
Solved! Go to Solution.
@G0ggs Hey ,
You can use this one
@G0ggs Hey ,
You can use this one
You can just wrap your CALCULATE statement inside an IF statement that checks if max('Date'[Date] is <= [stop date]
return your calculation if true, with no false option set.
Em I am struggling with how to write that formula? The stop date is always changing as it is just 45 days in the past.
Awesome thanks very much that worked!
Cheers
Hey @G0ggs ,
please create a pbix file that contains sample data but still reflects your data model (tables, relationships, columns, calculated columns, and measures). Upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method share the xlsx as well.
Regards,
Tom
Sorry it's sensitive info so can't upload
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |