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.
Hey Guys,
The data I am aggregating is user input so there are several errors time to time. The bigggest error is when a person inputs their badge number wrong so it does not have an appropriate lookup in the relation table to display their name on the charts. Instead of showing up as "(Blank)" on all subsequent charts, is there a way I can make all badge numbers that dont have a lookup show up as "ID Not Found".
Thanks in Advance!
Solved! Go to Solution.
Hi @Boveitj,
You can alsways use ISBLANK() funtion here to catch the ecxeption, use it in if condition to get the desired result.
Some thinglike :
IF(ISBLANK(LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>)),"ID Not Found",LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>))
Hope this helps
Regards,
Sumit
Hi @Boveitj,
You can alsways use ISBLANK() funtion here to catch the ecxeption, use it in if condition to get the desired result.
Some thinglike :
IF(ISBLANK(LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>)),"ID Not Found",LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>))
Hope this helps
Regards,
Sumit
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |