Using measure with MAX function in a visual

[Anonymous]

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 display the latest year and month i.e in this case 2021-09.
For the latest year I have created a 1/0 calculated column, since the data will at any given time will have only 2 years of data, so the latest year will take '1', this column is put in my visual filter pane so that it shows 2021 figure only in that visual card.
What I also want to show is the latest quarter data i.e in this case the card should show 2021-09 i.e Q3 number, this is something which also needs to go in the visual card filter pane.

Can anyone suggest any solution how can this be done?

[v-lionel-msft · Accepted solution]

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.

[Anonymous]

@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?

[Anonymous]

Yes perfect, exactly what I wanted! Thanks a lot @v-lionel-msft kudos!

[amitchandak]

@Anonymous , what is logic of latest month is 2021-09

[Anonymous]

The card visual which displays sales % has a year filter which always shows 2021 data, need to add one more filter which will also show the latest quarter month, i.e in the above case 9, when the 12 months are over this should automatically be changed to 12 and the card visual will be showing 2021 period 12 data. Let me know if that was helpful