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.

     

     

     

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver III
2 years ago

Hii numaan_99 

Use the below dax:

Count = Count(('Table (4)'[Term_id]))
 

Did I answer your question?

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

Hit the kudo also,

Thank 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.

  • Vallirajap's avatar
    Vallirajap
    Icon for Resolver III rankResolver III
    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.

     

     

     

    • numaan_99's avatar
      numaan_99
      Frequent Visitor
      2 years ago

      This gives me the solution. i would like to work with you could you please give me your number or any contact to connect

      • Vallirajap's avatar
        Vallirajap
        Icon for Resolver III rankResolver III
        2 years ago

        Hii numaan_99,

        I am really happy about your acknowledgement. Thank you for that.

         

        If you have any questions, mention me in your post to ask a question in the community.

         

        In rare cases, connect with me through email.

        [email protected]

         

        Did I answer your question?

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

        Hit the kudo also,

        Thank you