Filtering Without Filtering???

[amitchandak]

Just check a rank that can be created on the date within the customer. That will give you the order and based on that you can calculate your next or previous date.

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[littlemojopuppy]

Hi -

Thanks for replying.  I'm not getting it.  The biggest thing I'm not understanding is how would you limit sales transactions to only those of a specified customer without filtering?

Secondarily and far less important, if I rank sales transactions based on date, the first one would be ranked 1, the second one would be 2, etc.  Whether the second one happened within 90 days won't be reflected in a ranking...

I'm confused!  🙂

[littlemojopuppy · Accepted solution]

Redacted

[thatnerdguy]

Did this solution work for you?

[littlemojopuppy]

@thatnerdguy I would approach this in a completely different way now than I did four years ago.

Good luck with the interview! 😉