Forum Discussion
Saxon10
Post Prodigy
Post ProdigyFrequency based on the criteria
Hi,
How can I do frequence based on the criteria in Power BI using DAX.
I have a data table with information about the sales of products Id by customer with date.
What I`m trying to achieve here - How frequently we deliver the product id to the customer by date.
Data
| Date | Product ID | Customer | Qty |
| 05/05/2021 | 12345 | Tata | 1 |
| 05/05/2021 | 12345 | Tata | 2 |
| 05/05/2021 | 12345 | Tata | 34 |
| 05/05/2021 | 12345 | Tata | 5 |
| 05/05/2021 | 1254 | Hero | 8 |
| 05/05/2021 | 1254 | Hero | 9 |
| 05/05/2021 | 1254 | Hero | 10 |
| 05/05/2021 | 1254 | Hero | 11 |
| 05/05/2021 | 1254 | Hero | 12 |
| 06/05/2021 | 12345 | Tata | 1200 |
| 06/05/2021 | 1254 | Honda | 1 |
| 06/05/2021 | 1254 | Honda | 1 |
| 06/05/2021 | 1254 | Honda | 1 |
Hi Saxon10 ,
Here are the steps you can follow：
1. Create measure.
Sum = CALCULATE(SUM('Table'[Qty]),FILTER(ALL('Table'),'Table'[Customer]=MAX('Table'[Customer])&&'Table'[Date]=MAX('Table'[Date])))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Saxon10 ,
Here are the steps you can follow：
1. Create measure.
Sum = CALCULATE(SUM('Table'[Qty]),FILTER(ALL('Table'),'Table'[Customer]=MAX('Table'[Customer])&&'Table'[Date]=MAX('Table'[Date])))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Saxon10Hi,
Thank you so much for and reply.