Forum Discussion

moizsherwani's avatar
moizsherwani
Continued Contributor
8 years ago
Solved

Difficult Days Off During Pay Period Problem - Direct Query Mode

Hi guys,   I am haaving diificulty covering the last leg of a DAX measure (DirectQuery mode). It is to calculated the days a person has taken off during the pay period, so for example see table bel...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi moizsherwani,

     

    Try this DAX formula like below:

     

    …

return calculate(SUMX(LEAVE,DATEDIFF(TempStartDate,TempEndDate,DAY)), allexcept(LEAVE[EmployeeID]))

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi moizsherwani,

 

Try this DAX formula like below:

 

…

return calculate(SUMX(LEAVE,DATEDIFF(TempStartDate,TempEndDate,DAY)), allexcept(LEAVE[EmployeeID]))

 

Regards,

Jimmy Tao