Return second max date based criteria

[Sticks]

Hi all,

I am trying to return the second max date that a customer has purchased goods. In my fact table all customers have one of three values 1)in-active, 2) active, 3) partially active for each quarter. What I want to do is return the quarter start date (also in fact table) for the second max quarter (have already worked out latest quarter) that the customers status is either active or inactive?

Cheers

[v-jiascu-msft]

Hi @Sticks,

Can you share a sample please? The dummy pbix file would be great. I think you need a independent date table.

Best Regards,

Dale