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,
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