Forum Discussion
Referencing two columns from separate data sources in DAX
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[valu...
VasTg
Memorable Member
Memorable MemberAnonymous
It is possible..
Please post the sample inputs, how you want to define relationships and expected output to better answer you.
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.
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.