cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sticks Visitor
Visitor

Return second max date based criteria

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
1 REPLY 1
Community Support Team
Community Support Team

Re: Return second max date based criteria

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.