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.
I am able to achieve this as long as the running total is in a column ... however I would like to see the running totals as follows and hoping someone can advise the correct calculation if there is one.
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Year: 2021
Value 10 10 10 10 10 10 10 10 10 10 10 10
**bleep** total 10 20 30 40 50 60 70 80 90 100 110 120
Year: 2022
Value 10 10 10 10 10 10 10 10 10 10 10 10
**bleep** total 130 140 150 160 170 etc etc
Solved! Go to Solution.
@MarcUrdang , what is your source table structure , usually running total with Date or sortable month year (YYYYMM) you can get like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
or
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))
@MarcUrdang , what is your source table structure , usually running total with Date or sortable month year (YYYYMM) you can get like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
or
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))
Hi Amit .. that works perfectly ... just one more question ... now that the numbers are in a matrix .. I need another calc that works out the % diff ie ... not sure if i need to post another request for this ?
Jan
2021
Val 25
% dif
2022
Val 40
% diff 60
thanks SO much .. .have accepted as a solution
have a super weekend
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |