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, I am stuck with this dataset. My task is to calculate the Closing Balance for each and every month. But not sure, how do I achieve this. Can anyone please help?
To calculate the Closing Balance, the Logic is :
Prev.Month Closing Stock + Cur.Month Production + Cur.Month Receipts - Cur.Month Demand
The expected answer should be something like this:
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share your source data (not the format in which you want to see the report) in a format that can be pasted in an MS Excel file.
Hi @Ashish_Mathur
Here is the data as requested. I have received the data in the same format as below.
Product | Category | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 |
Cable | Demand | 4092 | 6050 | 3802 | 5784 | |
Cable | Receipts | 7030 | 4500 | 4615 | 5543 | |
Cable | Production | 0 | 0 | 0 | 2515 | |
Cable | Closing Stock | 4601 | ||||
Pipe | Demand | 7584 | 5894 | 4875 | 2254 | |
Pipe | Receipts | 2245 | 3332 | 2245 | 5578 | |
Pipe | Production | 125 | 0 | 664 | 3654 | |
Pipe | Closing Stock | 7825 |
Hi,
You may download my PBI file from here.
Hope this helps.
wow..
Thank you so much. This is what I am looking for.
You are welcome.
Here it is:
Product | Category | MAR 2022 | APR 2022 | MAY 2022 | JUN 2022 |
Cable | Demand | 4092.834 | 6050.999 | 3802.334 | |
Cable | Receipts | 7030 | 4500 | 4615.38 | |
Cable | Production | 0 | 0 | 0 | |
Cable | Closing Stock | 4601 |
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |