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 

Both of the output I proposed are basically the same thing, and the 1st output was just the summarized version of the 2nd one.  Did you want to have the same number of rows as your original table?  In that case, I would have imagined that the 2nd output will be closer to your required output.  I am sorry, if I am missing your point.  

Best regards,

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DataNinja777 ,

 

Sorry if I was not very clear.

 

Does this new sample explain what I am trying to achieve? 😊

I just need the same formula that you've shared with me (SUMMARIZE) to work inside my original datasource directly, so I can play with the rest of the columns (Color, Size, etc)

 

 

 

 

  • 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 

  • 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,