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.
hi i am new to power bi. i have a table
table name " value entry"
entry no | entry type | purchase amount | sales amount | cost |
1 | purchase | 10 | 0 | 10 |
2 | Sale | 0 | 20 | 10 |
3 | sale | 0 | 20 | 10 |
4 | purchase | 10 | 0 | 10 |
i want to get the profit value, normally i am doing with excel sum if formula to get the total cost and i will deduct the total cost of entry type sale. Please help.
I can't get your logic for Profit exactly. But, to calculate total cost, you can create a measure like:
Total Cost = SUM(ValueEntry[Cost])
For the total cost of entry type sale, you can write a measure like:
Total Cost = CALCULATE(SUM(ValueEntry[Cost]),FILTER(ALL(ValueEntry),ValueEntry[entry type]="Sales"))
Regards,
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |