Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

Anonymous 

 

It is possible..

 

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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.