Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to minus the cost actuals in a measure using
Actuals = if('SageFunctCodes$'[Type]="Cost",-SUM(Transactions[tran]),SUM(Transactions[tran]))
However when I put that measure onto the table it shows 0.00
Any ideas?
Thanks
Solved! Go to Solution.
Thanks lol,
Sage has the revenue as minus and costs as positive, I am trying to reverse this in PowerBI, I could do it in SQL but was looking for a measure to do it.
Just thinking I could do Actual = Sum(actual) * -1
Thanks
Chris
The approach you are taking is completely wrong. Can you please elaborate your issue and post the sample data if possible.
"I am trying to minus the cost actuals".??
Are you trying to put a minus sign in front of the "cost "??
Thanks lol,
Sage has the revenue as minus and costs as positive, I am trying to reverse this in PowerBI, I could do it in SQL but was looking for a measure to do it.
Just thinking I could do Actual = Sum(actual) * -1
Thanks
Chris
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |