Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Frequency 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 achie...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

To make it clear, can you post the expected output for the above given data?

 

Thanks

Raj