Calling a column from table B to another table A in the formula for creating a custom column

[Anonymous]

Hello,

I would like to create a personalized column on power bi in the table A which calculates the cost including tax in euros. For that i have the following formula :  Cost EuroTTC = (Cost$/(Marge+Cost$))*TVA

My problem is that the "Marge" and "TVA" are columns from a different Table named B and i don't know how to call them in Table A to create my personalized column Cost EuroTTC.

Can somebody please help me?

Thank you.

[v-yanjiang-msft]

Hi @Anonymous ,

My formula is DAX calculated column formula, please create it in a calculated column instead of using it in power query side, which is more easier.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The Cost is in a table "Data" and the marge and the TVA are in a different table "Facturation"

And the column Cost(TTC) that i want to create will be in the table "Data"

[Anonymous]

Hello @v-yanjiang-msft 

Thanks for helping.

i tried your formula and i have this error : "The column 'Facturation[#"Marge Inetum"]' does not exist or has no relation to a table available in the current context. 

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

My data model is just the same with your description, and the two tables should have a relationship.

When you enter the “RELATED(”, the next table will appear automatically.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @v-yanjiang-msft 

i have try the same process to create a new measure but i have this issue :

There is a relationship between the two tables DATA and TBBResume

But it seems to be an error saying : "Column 'TBBResume [Sauvegarde]' does not exist or has no relation to an available table in the current context."

[Anonymous]

Thank you so much. It works😊

[VahidDM]

Hi @Anonymous 

You can use LOOKUPVALUE or RELATED DAX functions to call them.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Anonymous]

it doesn't work. DAX did'nt recognise the RELATED OR LOOKUPVALUE function