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 all!
I run into a problem using CLOSINGBALANCEMONTH with data coming from two sources (one contains actual data and other one contains forecast). I want to calculate Inventory level and basically I want my pivot to show Inventory for Q1 on the same level as Inventory for March (eg. January Inv.=100, February Inv.=80, March Inv.=90, Q1 Inv.=90).
If I sum two CLOSINGBALANCEMONTH functions (one to calculate January Inventory (in this case actual data) and other one to calculate February and March Inventory (in this case forecast)) the result for Q1 is sum of January and March Inventory.
Does anyone have idea how can I solve this issue?
Thanks!
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |