Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hey @conorl
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |