How to count the outlet with no purchase with in the last 3 month

[CheanSereyvatan]

Hi BI Team,
I have 2 tables, 1 table is master Data with the outlet information and 1 more table is showing the daily sale record. I want to count the outlet that has no purchase in the last 3 month. Please help me o

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[Ritaf1983 · Accepted solution]

Hi @CheanSereyvatan 

Please refer linked discussion:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Customers-without-purchases-in-gt-6-...5

seems the same scenario as yours.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly