Forum Discussion
PatrickWong
Helper I
Helper INeed 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 machine. when I visualise the 2 table together, I am not able to get the total correct
,
create a new measure
M2 = SUMX(VALUES(Machine number),[SUM of Total availble hrs])
2 Replies
- Ahmedx
Super User
create a new measure
M2 = SUMX(VALUES(Machine number),[SUM of Total availble hrs])
PatrickWongThank you. works like a charm.