How to calculate distribution report

[CheanSereyvatan]

Dear Team,

Anyone can help me? I have a table with sale record from month to month. I want to count the outlet that have purchase in the last 2 + current month. let say 1 outlet if have purchase 1 time in these 3 month, we will count as 1.

Outlet ID	Jan	Feb	Mar	Count as Distribution Report
1044271	2	3	3	1
1044272	4			1
1044273	2	5		1
1044307		10	4	1
1044308	4		7	1
Outlet Count	4	3	3	5

Thanks you very much for your kindness.

[Anonymous]

Hi @CheanSereyvatan ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng