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,
I Have 2 related tables.
When i add fields from both to a table, rows where items in the first table are not match in the second table appear as blank or no values.
When this occurs, i would like to have th row display something like "no value found".
For example, both tables are linked by a employee name field. The first table is the "master" employee table, with all employees in the table. The second table contains info on employees. but not all employees have an entry.
When the employee name from the first matches an entry in the second table, in want the info from both printed on the row in the table. When no match is found, i want the employee name from the first printed in the table, with "no value" as the value for the second table.
Possible?
Solved! Go to Solution.
Hi @uthall,
You can add a calculated column in “master” table. I try to reproduce your scenario by creating “master” employee table like the first picture, and the information in second picture.
Then add a calculated column using the formula below. Create a table, select the Employee and column as values, you will get the expected result.
Column = IF(ISBLANK(RELATED(Table20[information])),"no value found", RELATED(Table20[information]))
Best Regards,
Angelia
Hi @uthall,
You can add a calculated column in “master” table. I try to reproduce your scenario by creating “master” employee table like the first picture, and the information in second picture.
Then add a calculated column using the formula below. Create a table, select the Employee and column as values, you will get the expected result.
Column = IF(ISBLANK(RELATED(Table20[information])),"no value found", RELATED(Table20[information]))
Best Regards,
Angelia
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 | |
99 | |
76 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |