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.

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Is there more data in your table that you need to retain outside of these fields you list, or could you not look at the full name and date fields and remove duplicates?

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

I need to keep those data. That duplicate means that person have 2 activity that day. Sorry about the confusion.