Forum Discussion
VOID
...
ricardocamargos
Continued Contributor
Continued ContributorAnonymous,
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
You just need to merge the datasets using the left join.
If u wanna use DAX u can use the function EXCEPT:
https://www.tutorialspoint.com/dax_functions/dax_except_function.htm
Thanks,
Ricardo
Veing a less sophistocated user and a bit of a newb, I used the following statement:
Column = CONTAINS(Table2, Table2[Value], Table1[Value])
This creates a True/Flase value. I change the value to text, and wrote an if statment that returns a vaule of Sold or Available. Not ideal - but functional.
What would you recommend at the easiest way to apply a DAX statement that returns a desired value i.e. Sold or Available, when an ID matches or not from two tables?
Thanks.