Calculated Column

[Anonymous]

Can i create a calculated Column in Power Bi using col from diff tables ?

Example - I have sales data in table1 

and i have cost data in table2

Can i calculate Revenue from these two measures ? 

Both the tables are joined based on order id

[v-jayw-msft]

Hi @Anonymous ,

You might be able to create calculated column based on columns from different tables, but it's not supported to create calculated column based on measures.

If you need help with DAX formula, please show some sample data and expected result to us.

Best Regards,

Jay

[ryan_mayu]

@Anonymous 

maybe you can try to use RELATED or RELATEDTABLE

https://docs.microsoft.com/en-us/dax/related-function-dax

https://docs.microsoft.com/en-us/dax/relatedtable-function-dax

[jaideepnema]

Hi @Anonymous ,
Why do you want to create a calculated column ? Cant a measure work in this case ?

Additionally can you please help with some sample data to look into your query ?

Regards,

Jaideep Nema

[Anonymous]

Hi Jaydeep

I dont want an aggregarted value, I want it corresponding to certain other parameters.

Like if you consider the same example given above, I may need revenue wrt each sector or region etc.