Forum Discussion
Solved
Create new column from a measure .
Hi All ..!! I am just wondering how to convert a measure to a new column in the Data . Basically i have 4 columns from two different tables . Table1[PersonID] Table1[HoursAllocated] Tabl...
Hi MartinAa ,
I created some data:
Table1：
Table2：
Here are the steps you can follow：
1. Create calculated column.
Column_Hours_Difference = 'Table2'[Actual Hours] - AVERAGEX('Table1','Table1'[HoursAllocated])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi MartinAa ,
I created some data:
Table1：
Table2：
Here are the steps you can follow：
1. Create calculated column.
Column_Hours_Difference =
'Table2'[Actual Hours] - AVERAGEX('Table1','Table1'[HoursAllocated])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly