Referencing two columns from separate data sources in DAX

[Anonymous]

Hi,

I am trying to create a column that uses columns from seperate data sources (One being an excel file and the other being SQL).

For example:
New Column = IF( Data1[value1] = 1, Data2[value2]/1000, Data2[value2])

Is this possible? Or is there another method?

[Anonymous]

Hey @Anonymous 

You can certainly do this and you are on the right track. However, since you are in Power BI and not excel it is a little different. You can't make row references so you will end up needing to use the FILTER or LOOKUP functions in Power BI (much like Vlookups in excel) to find the related value2 in data2.

[VasTg]

@Anonymous 

It is possible..

Please post the sample inputs, how you want to define relationships and expected output to better answer you.

[Anonymous]

First load excel data using get data amd excel source.
Then again click on get data and connect to sql server and load data.

If you want new column excel data that is in data1 table then first you need create relationship between these two table and write down your new column dax as per your requirement.


Thanks
Pravin
If it resolves your problem mark it as a solution and give Kudos.