Forum Discussion
VOID
Thanks Ricardo.
Yes, I think I will need more detail.
I have seen other functions here, but can't seem to get them to work.
Anonymous,
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.
Anonymous,
You can create a measure using the EXCEPT function, passing que ID`s.
Sold = VAR tbl1 = SELECTCOLUMNS(TABLE_1, "ID")
VAR tbl2 = SELECTCOLUMNS(TABLE_2, "ID")
VAR tbl = EXCEPT(tbl1; tbl2)
RETURN
COUNTX(tbl; ID)
Using this measure in a table you can visualize if it`s available or not, it will return 0 or non 0;
Thanks,
Ricardo