Hi Khadija,

I’ve tried to put an example together;

I created a Dimension for Client

And created a Metric of Client Type, structured by Month x Client (Using Dimension: Type)

Then I wrote the following formula;

'Client Type' yFILTER: Month.Year = Year."FY 22"] 2Remove LASTNONBLANK : Month]

This finds the last nonblank in the year FY22, and so excludes the Jan23 value.

I hope this helps with what you’re trying to achieve!

Hello  @Keiran, thank you so much for you answer,

Your answer actually solved the first part of my problem, and so I was wondering if there was a way to filter from FY 22 to current date out?

Thank you,

Hi @Khadija,

Do you currently store the ‘current’ month as a variable or Metric somewhere? Or would you need to do this also?

Thanks!

@Keiran ‘Current month’ is already stored as a metric in our application