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