Solved

Fill date informed before a date

Userlevel 2

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

Can you please help me with this?

icon

Best answer by Keiran 17 February 2023, 11:17

Userlevel 4

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

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

Hi @Khadija,

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

Thanks!

Userlevel 2

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

Sign up