Forum Discussion

PowerBIFreak's avatar
PowerBIFreak
Icon for Helper II rankHelper II
3 years ago
Solved

New Column with IF STATEMENT

Hi Folks, I have a table with some columns as below. The print screen below is a table from Power BI. This is perfect if I just want to see each employees' hours on a daily basis. However, I would l...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    PowerBIFreak 

    is this what you want?

     

    Column 2 = if('Table'[Column]="OT", CALCULATE(sum('Table'[Hours]),ALLEXCEPT('Table','Table'[Date],'Table'[Employee]))-8,0)

     

  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    pls provide the sample data

PowerBIFreak's avatar
PowerBIFreak
Icon for Helper II rankHelper II
3 years ago

Sorry for the delay. Yours look exactly what I need but when I applied the code to mine, the calculation is totally off. I don't know what happened. Thank you so much for your time.😊🙏

 

 

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

pls provide the sample data

  • PowerBIFreak's avatar
    PowerBIFreak
    Icon for Helper II rankHelper II
    3 years ago

    Good morning Ryan. Thank you very much for following up. I think I don't need further assistance because the report that I downloaded did indicate the OT hours for each employee outside of the normal hours. That way, I can just filter them out when I did the report. Thank you again for your help. Have a great day.