Forum Discussion
hejszyszky
4 years agoHelper II
Exclude multiple values from calculated column
Hi, Given code and output below, id like to exclude multiple values based on date and name. IF I have more than one row of same Date&Name id like to output calculation (330) only in one row. ...
- 4 years ago
Hi hejszyszky ,
Since I do not have your specific data, I have created a template data based on what you have provided so far:
Then use the below dax to create a new column:
final = VAR index11 = RANKX ( FILTER ( 'Summarized Raport', 'Summarized Raport'[Data] = EARLIER ( 'Summarized Raport'[Data] ) ), 'Summarized Raport'[Zmiana(A,B,C,D)], , ASC ) RETURN IF ( index11 = 1, SUMX ( FILTER ( 'Summarized Raport', 'Summarized Raport'[Data] = EARLIER ( 'Summarized Raport'[Data] ) ), 'Summarized Raport'[value] ), 0 )Final output:
You can adapt my code to your specific environment and needs.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
hejszyszky
4 years agoHelper II
Hi, vojtechsima
Thanks for your fast reply!
I am facing some issues, i believe its with Index column. In your scenario,Index column, is it just a row number?
vojtechsima
4 years agoSuper User
Hi, hejszyszky
It's just a simple Index column generated by Power Query:
However, it really helps with your issue.
- hejszyszky4 years agoHelper II
Well thats unlucky, cuz my table is an dax expression 😐