Forum Discussion

PatrickWong's avatar
PatrickWong
Icon for Helper I rankHelper I
2 years ago
Solved

Need Help: column total

I have 2 table set which is related by the date. in first table, it is just the date and hour available for that date (range). on the second table, I have machine and how much time is used on the mac...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    create a new measure

    M2 =  SUMX(VALUES(Machine number),[SUM of Total availble hrs])

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

create a new measure

M2 =  SUMX(VALUES(Machine number),[SUM of Total availble hrs])

  • PatrickWong's avatar
    PatrickWong
    Icon for Helper I rankHelper I
    2 years ago

    Thank you. works like a charm.