Forum Discussion
Using measure with MAX function in a visual
Hi all, I have attached a snippet of how my data is in the image above. Basically I have a calculated "Sales%" measure in a card visual to which I have to apply a filter, which will always dis...
Hi Anonymous ,
Is this what you want?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Is this what you want?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes perfect, exactly what I wanted! Thanks a lot v-lionel-msft kudos!
v-lionel-msft Slight modification help needed, instead of using today() in the var syntax, how can I keep it to max of the month in a year. The data provided has its year cycle from June-May, so currently it is the 12th month, hence I need the '1' for 2021-12 month and rest it would be zero, how can I achieve that?