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.
I want to create a measure called Products Available => It is derived from [Product Opening Balance] and just gives me the closing balance for the previous month as the opening balance of the new month. That is why I have this measure; Product Opening Balance = VAR PreviousClosingBalance =
CALCULATE([Product Closing Balance], DATEADD('Calendar'[Date], -1, MONTH))
RETURN
IF(PreviousClosingBalance < 0, BLANK(), PreviousClosingBalance)
I now want to add [Product Opening Balance] to two other measures to make create the [Products Available] measure => ([Company SKUs] and [Monthly Forecasted Returns).
Recall I said [Product Opening Balance] is determined by [Product Closing Balance]. The DAX for Product Closing Balance = [Product Opening Balance] - [Product Demand]. When I add [Product Opening Balance] + [Company SKUs] + [Monthly Forecasted Returns] to get Products Available, I run into a circular dependency issue.
Which I think is caused by [Product Opening Balance] being determined by [Product Closing Balance]. Please What do I need to do to avoid this, kindly recommend the most efficient DAX code to solve this problem.
Hi,
Share the dowload link of the PBI file and show the expected result.
Hi Ashish, unfortunately I couldn't share the EXACT pbix due to data privacy. However, I'll attach what I hope to achieve, thanks a lot!
https://drive.google.com/drive/folders/1auVqelWMCHiYW6UVGmsGIirp9acWx5RP?usp=sharing
Hi,
I do not understand your question at all. Show the expected result very clearly.
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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |