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 .
Table2[HoursDifference]---> Measure. (Which gives the correct results)
The above Measure is -
Hours_Difference = AVERAGEX(Table2, Table2[Actual Hours] - AVERAGEX(Table1, Table1[HoursAllocated]))
What i need to do is instead of creating this as Measure , i need to create this as a new column in Table2 Data.
So when i try to paste the measure in NewColumn , it gives the same single result for all the records which is wrong.
Thank you in Advance for your knowledge contribution...!!