topic Unable to reference columns field while creating a calculated column in DAX in DAX Commands and Tips

Unable to reference columns field while creating a calculated column in DAX

eddie_rasheed — Thu, 12 Oct 2023 06:12:42 GMT

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 🙂

@alhyde

Regards,

Eddie

Re: Unable to reference columns field while creating a calculated column in DAX

tamerj1 — Thu, 12 Oct 2023 08:19:35 GMT

Hi eddie_rasheed

you can use RELATED function to fetch columns from the BIitems-TI table.

Re: Unable to reference columns field while creating a calculated column in DAX

eddie_rasheed — Thu, 12 Oct 2023 08:41:07 GMT

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!