Forum Discussion
IF SUM dax issue
Hi Anonymous ,
I think you already have your own answer.
You can create the matrix like above from what you already have.
Best regards,
This one does not help me 😢. Your previous solution in post #7 was the right one. But I would just need to replicate it directly inside the original datasource with all my data. Not as a separate table function. Is this possible?
What I am trying to achieve in the end is something like below. However, I need the "Grouping" to be a calculated column that performs the same result, but directly inside my datasource.
Basically I need your calculation to happen in my datasource:
Super UserHi 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,
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
Hi Anonymous ,
I think you already have your own answer.
You can create the matrix like above from what you already have.
Best regards,
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)