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.
Hi,
I think this should be something simple that I am completly overlooking here so appolgoies if its an easy option but I cannot find it for the life of me.
Anyway, I have two tables, both with UserID. Table 1 contains records without a corresponding match in Table 2 between the relationship.
Rather than just show blanks, can I have this say like 'Unknown user' or something?
I cannot change the data source to include the records.
I figure I can do it via some method of mulitle merges with a join and an anti join then replace nulls with my text then merge it all back together but this seems overly convulted.
Cheers,
Scott
Solved! Go to Solution.
You could create a new column like below:
Column = IF(
SUMX(Table2,
FIND(
Table2[Userid],
Table1[Userid]
,,0
)
) > 0,
"Yes",
"No"
)
@Anonymous , if you do not want to create a new table or column, I doubt that is possible.
Hi, thanks for the follow up 🙂
No simple function I am just missing then? I guess a new table it is..
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |