Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a bunch of em_codes associated with my calculated column ALRemain. I want a new column which divides the ALRemain by a value associated with the em_code (the hours column), which can be found in my EmCode Table.
What would be the best method to achieve this?
Thanks
Solved! Go to Solution.
@Spencer Create relationship between Hours and ALRemain table using em_code column ie 1 to many relation from Hours table to ALRemain table. Then in ALRemain table create calculated column as below,
='TABLENAME'[alremain] / RELATED(TABLENAME[hours])
@Spencer Create relationship between Hours and ALRemain table using em_code column ie 1 to many relation from Hours table to ALRemain table. Then in ALRemain table create calculated column as below,
='TABLENAME'[alremain] / RELATED(TABLENAME[hours])
Yes that's it!
Thanks very much.
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |