Forum Discussion
Display non matching values in a table
Hi Everyone
Kindly assist, I am new to power bi.
I have 3 queries (Employee Data, Leave Taken and Leave Balance).All of them are linked through an employee ID.
I need to display the total number of leave days and leave type from Leave Taken along with leave balances . The challenge is for some employees the leave type is not the same, using the lookupvalue funtion I am able to get the matching value. But now I want to display the non matching value as well in a separate row.
Your response will be highly appreciated.
3 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - v-luwang-msft
Community Support
Hi Anonymous ,
Test the below:
Match = IF ( LOOKUPVALUE ( 'OML Leave Taken'[Time Off Type for Time Off Entry], 'OML Leave Taken'[Time Off Type for Time Off Entry], 'OMl Leave Balance'[Time Off Plan]) = BLANK (), "Not A Match", "Match" )If question not solved ,could you pls share a sample data and expected output?
Best Regards
Lucien
- v-luwang-msft
Hi Anonymous ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
