Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
103 | |
77 | |
71 |