Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Find Max Day per Week

Hello - I have a database where each time a punch is read it counted and put in as a row. Total for that day is the number of rows added (does have a date of punch column)   I want to find what day...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    I think you have misunderstood my data, and the last day of each week only represents this week and the max value is not the end day's value.

    So i add an column to the original table:

    Week = SWITCH('Table'[WeekEnd],DATE(2020,2,8),"Week-1",DATE(2020,2,15),"Week-2",DATE(2020,2,22),"Week-3")

    And i think you should already have the column like the above to represent each week.

    The result shows:

    Here is my test pbix file:

    pbix 

     

    Best Regards,

    Giotto Zhi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It's only getting the max value for the last day of the week. I'm looking to take the max per week, not just the max at the end of the week

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

I think you have misunderstood my data, and the last day of each week only represents this week and the max value is not the end day's value.

So i add an column to the original table:

Week = SWITCH('Table'[WeekEnd],DATE(2020,2,8),"Week-1",DATE(2020,2,15),"Week-2",DATE(2020,2,22),"Week-3")

And i think you should already have the column like the above to represent each week.

The result shows:

Here is my test pbix file:

pbix 

 

Best Regards,

Giotto Zhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I'm still not getting correct results