Forum Discussion

mlmagl14's avatar
mlmagl14
Icon for Helper I rankHelper I
4 years ago
Solved

DAX to Count Sales

Hello,    I have a table in which the receipt ID represents a customer, so the receipt ID can occur multiple times if the customer purchases multiple items from the store per day. It also shows the...
Need Help
  • darshaningale's avatar
    darshaningale
    4 years ago

    In power query , group by Date , Receipt Id and Add aggregation for sum of total retail price.

    Add another conditional column for 95+ based on the aggregated column.

     

    Regards
    DI

    Did I answer your question? Mark my post as a solution, this will help others!
    Kudos are also welcome.

darshaningale's avatar
darshaningale
Icon for Resolver II rankResolver II
4 years ago

In power query , group by Date , Receipt Id and Add aggregation for sum of total retail price.

Add another conditional column for 95+ based on the aggregated column.

 

Regards
DI

Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.

  • mlmagl14's avatar
    mlmagl14
    Icon for Helper I rankHelper I
    4 years ago

    Hi, thanks for your reply. Am I creating a new table to group by date and reciept ID in the power query? If you dont mind, can you tell me steps on how to do this? I'm still new to power bi and I don't know how to do what you suggest. Thanks in advance

    • darshaningale's avatar
      darshaningale
      Icon for Resolver II rankResolver II
      4 years ago

      provide sample data in excel and then i can send you steps/pbix file.

      • mlmagl14's avatar
        mlmagl14
        Icon for Helper I rankHelper I
        4 years ago

        I actually figured it out using your suggestions. Thank you so much for help. I really appreciate it!