| Outlet ID | Outlet Name | Order Date | Product | Qty | Net Value |
|---|---|---|---|---|---|
| Mum_1 | Prime Traders | 12th Oct 2022 | RoundBox | 3 | 300 |
| Mum_4 | Avon Trading | 13th Oct 2022 | Slice 100 | 10 | 1000 |
I have date wise transaction data for past 20 months for retail outlets. Any outlet that has been billed in the last 3 months can be classified as an 'Available Outlet'. Eg: Available outlets for Sept 2022 are the ones that have been billed at least once across July, August & Sept 2022. Similarly I need to have ,month wise availability count in a column chart. Can someone please guide as to how can I write a DAX query for the same ?