Forum Discussion

Saranya_Tamil's avatar
Saranya_Tamil
Frequent Visitor
3 years ago
Solved

Need help in DAX

Hi, I have 2 tables. Table A shows the number of hours eligible to work and Table B shows how many hours they actually worked. I need to calculate Time% i.e.  (hours/Time)*100 for each resource for ...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    Hi Saranya_Tamil ,

    You can try the below formula in calculated column,

     

     

    Output Column = 
VAR _lookupvalue = LOOKUPVALUE('Table A'[Time],'Table A'[Resource],'Table B'[Resource])
VAR _output = DIVIDE('Table B'[hours],_lookupvalue,0)*100
RETURN _output

     

     

    Thanks,

     

Arul's avatar
Arul
Super User
3 years ago

Hi Saranya_Tamil ,

You can try the below formula in calculated column,

 

 

Output Column = 
VAR _lookupvalue = LOOKUPVALUE('Table A'[Time],'Table A'[Resource],'Table B'[Resource])
VAR _output = DIVIDE('Table B'[hours],_lookupvalue,0)*100
RETURN _output

 

 

Thanks,