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.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Hello I have a problem with my analysis I have to calculate the absenteeism but for this I have my table of hours generated by the collaborators and my table of dates that is like calendar.

This calendar table I have configured so that it is with fiscal year and fiscal month that always starts from October to September, when I want to relate my table dates with my table of HH (table of assistance of the collaborators), I get the erroneous data since the days worked by each collaborator despite that I do functions go wrong in the same way the hours of each collaborator even so I put a screenshot if you can support me they respond with their email to send them the project.