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.
Hi
I am in learning stage of Power BI. I came across a problem. I have a table with 2 column namely: Entry_date and profit. I want to add a Cumm Profit2 column which can calculate running total profit for each row except for the 1st row as it will remain the same. If you refer to the picture the Cumm Profit2 is not matching Cumm Profit. Kindly point out the Mistake.
Solved! Go to Solution.
Hello,
Make sure you first understand the concept of row and filter context first,
Here replace sales column to "Profit" column, sheet1 with your table name and date with "Entry date"
Hello,
Make sure you first understand the concept of row and filter context first,
Here replace sales column to "Profit" column, sheet1 with your table name and date with "Entry date"
Thank you for help
try to modify the formula with below
1. filter(all(table)
2. "MIN" to be replaced to "Max".
User | Count |
---|---|
52 | |
46 | |
20 | |
16 | |
14 |
User | Count |
---|---|
108 | |
51 | |
30 | |
20 | |
18 |