Forum Discussion

yiying's avatar
yiying
Icon for Helper I rankHelper I
8 years ago
Solved

How to calculate days worked

So here is my data Full Name Date Days Worked ANTHONY  3/1/2018 0:00 1 ANTHONY  3/3/2018 0:00 1 ANTHONY  3/6/2018 0:00 1 ANTHONY  3/7/2018 0:00 1 ANTHONY  3/7/2018 0:00 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi yiying,

     

    Try out this measure please.

    Measure =
COUNTX (
    SUMMARIZE ( 'Complete WO', 'Complete WO'[Full Name], 'Complete WO'[Datekey] ),
    [Datekey]
)

    How_to_calculate_days_worked

     

    Best Regards,

    Dale

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    This measure gives 12 as the answer

     

    =COUNTROWS(SUMMARIZE(Data,Data[Full Name],Data[Date]))

     

    Hope this helps.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi yiying,

 

Could you please mark the proper answer as solution?

 

Best Regards!
Dale