Forum Discussion
Unable to reference columns field while creating a calculated column in DAX
Hello,
I'm attempting to create a calculated column in DAX to subtract values from two different tables belonging to distinct datasets. I've established a relationship between these tables using a Many to One cardinality, and 'No' serves as a common field. My goal is to introduce a new column in the 'BISalesLine_TI' table, where both tables feature a 'Unit Price' column that I need to subtract. However, when I attempt to formulate this, I encounter an issue with referencing the 'BIItems_TI' table. I've also experimented with the 'RELATED' function, but I'm facing the same problem. It might be a straightforward matter, but I'm encountering some difficulties. Your guidance would be greatly appreciated. Just a newbie getting introduced to Power BI 🙂
Regards,
Eddie
2 Replies
you can use RELATED function to fetch columns from the BIitems-TI table.
tamerj1 Thank you for addressing. I'm getting the below error when trying to use related function. I already have relationship between the tables though.
Thannks!
