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.
Anonymous , what is logic of latest month is 2021-09
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