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.
Hi,
Im pretty new to power BI and DAX, I have the running total calculated using the formula below for accounts:
hi, @mloc1990
The best way is that add a group column for date column (uwtest[authdate] )
Then add a conditional in the measure
Running Total = CALCULATE(SUM(uwtest[volume]),FILTER(ALL(uwtest),'uwtest'[authdate]<=MAX(uwtest[authdate]) && 'uwtest'[group] = MAX('uwtest'[group])),VALUES(Accounts[accountname]))
Best Regards,
Lin
It's definitely along the lines of what I am needing but when I add the group column I can only select a predefined period that will be the same for all accounts. In the attached images is it possible to do the same setup using a measure I have created called "Medium Days" as each account has a different amount of days for running total.
Thanks!
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |