Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
manikumar34
Solution Sage
Solution Sage

Blank values are overriding from the last year values

I have  created measures for current and previous year but some of the values which are not in the previous year are taking the values from the present year.  I have highlighted the values. please knidly help regarding this isssuue. 

 

Previous PC Manufacturing Cost = DIVIDE(SUMX(Sheet1,IF(Sheet1[pc_finyr]=Sheet1[min pc_finyr],Sheet1[ Total Cost ],0)),SUMX(Sheet1,IF(Sheet1[pc_finyr]=Sheet1[min pc_finyr],Sheet1[Qty in Ton Adjusted],0)),0)
 
Current PC Manufacturing Cost = DIVIDE(SUMX(Sheet1,IF(Sheet1[pc_finyr]=[max pc_finyr],Sheet1[ Total Cost ],0)),SUMX(Sheet1,IF(Sheet1[pc_finyr]=[max pc_finyr],Sheet1[Qty in Ton Adjusted],0)),0)
 

Overrided.PNG





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

The values for last manufacturing cost/tonn are not in my dataset. The values which are not present in the dataset are taking from the current manufacturing cost/tonn. 





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.