- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dividing by column in another table
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
AL Remain
EmCodes Table
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes that's it!
Thanks very much.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-10-2024 04:28 AM | |||
12-22-2023 06:49 AM | |||
Anonymous
| 04-18-2023 06:18 AM | ||
02-16-2024 10:07 AM | |||
Anonymous
| 09-13-2019 12:31 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |