Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
8 years ago
Solved

sum if

Good morning Community,    I try to make a sum if with column.    I  have a table with name, days and how many hours the guy work per day.  Nom  Monday Tuesday Wednesday Thursday Friday ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Milozebre,

     

    You should unpivot tables first in Query Editor mode.

     

    Then, new a measure as below.

    Count working days = CALCULATE(COUNT(Table_1[Weekdays]),Table_1[Value]>0)

     

    Best regards,

    Yuliana Gu

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

Hi Milozebre,

 

You should unpivot tables first in Query Editor mode.

 

Then, new a measure as below.

Count working days = CALCULATE(COUNT(Table_1[Weekdays]),Table_1[Value]>0)

 

Best regards,

Yuliana Gu

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
8 years ago

v-yulgu-msft

 

Thank you. 

Its working fine.