Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I need some help with Power BI pro. I am trying to replicate a vlookup we used in excel which basically is this:
=IFERROR(VLOOKUP(B3*1,Mapping!$P:$Q,2,FALSE),"No Group")
I have been able to use Column 1 = RELATED('Report 2'[Group]) which pulls the correct field but on instances where there is no match I want it to display "No Group"
Thanks
Solved! Go to Solution.
Hi @Bilal_321321,
the Lookupvalue formula returns blank if it doesn't have a match in the lookup (lookpvalue formula) try changing your formula to this:
Column = SWITCH ( TRUE (), ISBLANK ( LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] ) ), "NoGroup", LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Bilal_321321,
You need to do a formula with the following sintax:
Column = IFERROR ( LOOKUPVALUE ( Table[Result], Table[Search_Value], "Value_to_Search" ), "No Group" )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi MFelix,
I must be doing something wrong, the LOOKUPVALUE is working but for instances it's not got a value the "No Group" is not populating. This is the formula i have created so far:
Column = IFERROR ( LOOKUPVALUE('Report 2'[Group],'Report 2'[GroupID],'Report1'[GroupID]) , "No Group")
The 'Report 2'[Group] is the table and column I'm looking at, 'Report 2'[GroupID] is the linked field I am searching based on 'Report'[GroupID] and the "No Group" should appear instead of blanks.
I'm probably making an obvious mistake but can't see it.
Thanks
Bilal
Hi @Bilal_321321,
the Lookupvalue formula returns blank if it doesn't have a match in the lookup (lookpvalue formula) try changing your formula to this:
Column = SWITCH ( TRUE (), ISBLANK ( LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] ) ), "NoGroup", LOOKUPVALUE ( Report2[Group], Report2[GroupID], Report1[GroupID] ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |