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[value2]/1000, Data2[value2])

Is this possible? Or is there another method?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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'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.