Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
So i want to create a line chart, axis are dates, value is the achievement process of sales goal.
Lets say on dez 31 2019 the achievement was 100%, but when inserted in a line chart it shows the daily achivement, so everyday has about the same line height.
What i want instead is summing up the values from previous dates, so dez 31 has the whole 100% and you can see the trend.
Thanks and regards
Solved! Go to Solution.
Hi @Anonymous
see figure:
Regards Frank AT
Try like
last Day= CALCULATE(SUM(Sales[Sales Amount]),(dateadd('Date'[Date],-1,DAY)))
Thanks for the quick response @amitchandak
Didnt work for me, gives me the same result as just adding the measure by itself.
I think i forgot to mention the achivement goal is a measure, so i cant sum it..
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |