Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please help, I'm currently struggling getting the same result from Excel in to Power BI. So basically I need to do a vlookup from table 1 and table 2 and returned result from Table 2 Column E and F.
CTR Column
=VLOOKUP(S2,'Table 2'!$C$2:$F$57310,3,FALSE)
3 is where the result returned from Table 2 Column E
CTR Status
=VLOOKUP(S2,'Table 2'!$C$2:$F$57310,4,FALSE)
4 is where the result returned from Table 2 Column F
I've tried this vlookup formula but it doesn't seems to be working or not the result I wanted.
Can someone please help?
Thank you
Solved! Go to Solution.
Hi @Stuznet,
In DAX you should use the LOOKUPVALUE formula (see documentation here😞
LOOKUPVALUE( Table2[CTR_Num, Table2[VI_Key], Table1[VI_Key])
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Stuznet,
In DAX you should use the LOOKUPVALUE formula (see documentation here😞
LOOKUPVALUE( Table2[CTR_Num, Table2[VI_Key], Table1[VI_Key])
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you so much, it worked.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |