Hello,
I got a question. I Use this Measure to Create a sum dependend on Jahr and Kto-Nr.
Now I want to build in a rankx or rank.eq dependend on Jahr and Umsatz. How can I do something like that?
Thanks for any help.
By the way is there a code tag for DAX or M?
I got a question. I Use this Measure to Create a sum dependend on Jahr and Kto-Nr.
Now I want to build in a rankx or rank.eq dependend on Jahr and Umsatz. How can I do something like that?
Thanks for any help.
Code:
=CALCULATE (
SUM(source[Umsatz]);
Filter(source;source[Jahr]=EARLIER([Jahr]));
Filter(source;source[Kto-Nr]=EARLIER([Kto-Nr]))
)
By the way is there a code tag for DAX or M?