Forum Discussion

kingchad5's avatar
kingchad5
Helper I
9 years ago
Solved

Sum data by Date

I am trying to total the duration of an appointment for a user by date.  In the below table, I want to see 5 rows one per date.  I am able to get totals, but it is for all users not per user.  Any th...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi kingchad5,

     

    You can create a measure like below:

     

    Measure = CALCULATE(SUM('Table1'[duration_hours]),FILTER(ALL('Table1'),'Table1'[full_name]=MAX('Table1'[full_name]) && 'Table1'[date_only]=MAX('Table1'[date_only])))

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi kingchad5,

 

You can create a measure like below:

 

Measure = CALCULATE(SUM('Table1'[duration_hours]),FILTER(ALL('Table1'),'Table1'[full_name]=MAX('Table1'[full_name]) && 'Table1'[date_only]=MAX('Table1'[date_only])))

 

 

Best Regards,
Qiuyun Yu