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 would like to add a simple projection of production through years end to the bottom Stacked Column Chart:
I want to take production YTD through Q3 and multiply by (12 / 9) and have the difference displayed as Q4 data in the lower chart.
I'm not sure of the best way to accopmlish this, and any help is greatly appreciated!
Thank you!!
Solved! Go to Solution.
My lack of DAX knowledge was the only problem!
I apologize for the clutter, and I appreciate the support!
Your question is not clear for me. Could you post any sample data? Even better you can upload the pbix file to OneDrive or any web drive and share the download link. Do note to mask sensitive data before uploading.
My files uses several data sources, including an on-premise SQL server, so it may be easier to explain with screenshots.
I have got very close to what I was trying to accomplish. I created a new table that summarizes Production data in a table:
Resulting Table:
Now I want to replace the 4th Quarter value with (Q1 + Q2 + Q3) / 9*12, so I need a DAX formula to replace the '0' with in this function:
I'm not sure how to add the 1st through 3rd quarters up.
Any help is greatly appreciated!
Thanks again!
My lack of DAX knowledge was the only problem!
I apologize for the clutter, and I appreciate the support!
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |