Forum Discussion

numaan_99's avatar
numaan_99
Frequent Visitor
2 years ago
Solved

calculating unique count based on a filtered condition

i have three columns "term_id_new", "Sale Date" from the same table "Sale Items". Now i want to keep only those "term_id_new" whose first "Sale Date" is 20/12/2023. How to do that in powerbi ...
Need Help
  • Vallirajap's avatar
    Vallirajap
    2 years ago

    Hii numaan_99,
    Based on my understanding, I found the solution below

    Try this,

     

    1. Minimum of sael date for each Term_id:

     

    2. Terminal Id for the last date 20/12/2023:

     

    Did I answer your question?

    Mark my post as a solution, this will help others...!

    Hit the kudo also,

    Thank you.

     

     

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

in this scenario you do not need any measures, the filter will do everything for you

 

numaan_99's avatar
numaan_99
Frequent Visitor
2 years ago

but i need to find out minimum of "sale date" for each terminal id. then out of those, i only need to keep terminals IDs whose last date is 20/12/2023. i need to create a separate column for this. and using that column, i will do some calculations in future. please provide me any queiry formulas in detail.