Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

IF SUM dax issue

Hi,   Can someone help me with this situation I am confronting with?   Based on the raw data on the left, I need to reach to the result on the right, but IF(SUM) is not evaluating correctly. What...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Anonymous ,

    I think you already have your own answer.  

    You can create the matrix like above from what you already have.  

    Best regards,

     

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

I think you already have your own answer.  

You can create the matrix like above from what you already have.  

Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DataNinja777 ,

 

Many thanks🎉! This one involving EARLIER is the right one. Sorry, I might have missed something, but I've tried it out again and it works perfectly!

 

Regards