Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |