Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello guys. I think this should be an easy one, but I have no ideas..
I have this table where (by day) I have a list of Sales. Also I have a Objective column.. What I need to do is to see the Difference between these two colums (I mean Sales - Obj) and then a new column which shows a cumulative sum of the Difference.. Example:
Day Obj Sales Diff Diff cumulative
01/01/2018 1200 1330 130 130
02/01/2018 1399 1100 -299 -169
03/01/2018 344 131 -213 -382
04/01/2018 414 2323 1909 1527
05/01/2018 235 414 87 1614
06/01/2018 2535 242 -2293 -679
07/01/2018 2353 412 -1941 -2620
Thanks you all guys!
OC
Solved! Go to Solution.
Hi @omarevp
First, create your new column :
Diff = YourTable[Sales] - YourTable[Obj]
Then add a new column
Diff cumulative = CALCULATE ( SUM (YourTable[Diff] ), ALL ( YourTabke), YourTable[Day] <= EARLIER (yourTable[Day]) )
Have a good day
- Quentin
Hi @omarevp
First, create your new column :
Diff = YourTable[Sales] - YourTable[Obj]
Then add a new column
Diff cumulative = CALCULATE ( SUM (YourTable[Diff] ), ALL ( YourTabke), YourTable[Day] <= EARLIER (yourTable[Day]) )
Have a good day
- Quentin
Hello @quentin_vigne the thing is, SUM function doesnt allow a measure as an argument.
Your first column should not be a measure but a calculated column. You want the Diff for each row
Create your difference as a calculated column and it should work
- Quentin
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |