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.
Hello all,
I have a question about translating an Excel function to Power BI. I've already searched around and came across different DAX solutions, I only get this not working.
I would like to apply the Excel formula below to Power BI.
= IF ($ N2 = "NO XX"; M2; IF (VLOOKUP ($ Z2; TABLE2! AB: AE; 4; FALSE)); "No Match with XX"; VLOOKUP ($ Z2; TABLE2! AB: AE; 4; FALSE)))
The values N2 and M2 are in TABLE1 and if they are not "NO XX" then he will look in TABLE2.
Can someone help me on my way?
Thanks in advance
Solved! Go to Solution.
@haassiej,
Create a column using DAX below.
Column = IF(Table1[N]="No XX",Table1[M],IF(ISBLANK(LOOKUPVALUE(Table2[Column4],Table2[Column1],Table1[Z])),"No match with XX",LOOKUPVALUE(Table2[Column4],Table2[Column1],Table1[Z])))
Regards,
Lydia
@haassiej,
Create a column using DAX below.
Column = IF(Table1[N]="No XX",Table1[M],IF(ISBLANK(LOOKUPVALUE(Table2[Column4],Table2[Column1],Table1[Z])),"No match with XX",LOOKUPVALUE(Table2[Column4],Table2[Column1],Table1[Z])))
Regards,
Lydia
Thanks for your reply!
Have your columns a join/relationship with each other? My tables in Power BI doesn't have an relationship.
@haassiej,
There is no relationship between the tables in my scenario.
Regards,
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 |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |