Forum Discussion
Need to create interdependent measures
Would you please update your description and include source data that can be pasted into Excel or supply a sample .PBIX, and not as an image. What you supplied is not complete. If you are calling out Tables and columns or variables in DAX you intend to use in measures or columns, please ensure that the table and columns appear in the model. As well, please ensure that you use a dedicated Dates table and that any necessary relationships are set up in your model.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi! Thank you for taking time to provide the information! I will surely keep the points you mentioned in mind. I did go through a ton of posts before posting my question here. Unfortunately, I cannot share my PBIX file, however, I shared my excel workbook to another reply.