Fill date informed before a date

  • 9 February 2023
  • 4 replies

Userlevel 2
Badge +1

Dear community, 

I hope this you’re all well.


This is the metric I want to fill my dimension property with:

My quest is: I want it to give me the last client type filled before January 23

My metric

Can you please help me with this?


Best answer by Keiran 17 February 2023, 11:17

View original

4 replies

Userlevel 4
Badge +3

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' [FILTER: Month.Year = Year."FY 22"] [Remove 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!

Userlevel 2
Badge +1

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,


Userlevel 4
Badge +3

Hi @Khadija,


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



Userlevel 2
Badge +1

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