Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
...
Hi @Anonymous,
You can use the merge (left join) function in Power Query. When the right side is null it`s available.
Let me know if u need some help.
Thanks,
Ricardo
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
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |