VOID

Question

...

ricardocamargos · Answer

Hi&nbsp;Anonymous,&nbsp;You can use the merge (left join) function in Power Query. When the right side is null it`s available.&nbsp;Let me know if u need some help.&nbsp;Thanks,&nbsp;Ricardo

anonymous · Answer

Thanks Ricardo.&nbsp;Yes, I think I will need more detail.&nbsp;I have seen other functions here, but can't seem to get them to work.&nbsp;https://community.powerbi.com/t5/Desktop/DAX-query-to-compare-a-value-in-one-table-to-see-if-it-exists-in/m-p/56613#M23053

ricardocamargos · Answer

Anonymous,&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data&nbsp;You just need to merge the datasets using the left join.&nbsp;If u wanna use DAX u can use the function EXCEPT:&nbsp;https://www.tutorialspoint.com/dax_functions/dax_except_function.htm&nbsp;Thanks,&nbsp;Ricardo

anonymous · Answer

ricardocamargos&nbsp;Veing a less sophistocated user and a bit of a newb, I used the following statement:&nbsp;Column = CONTAINS(Table2, Table2[Value], Table1[Value])&nbsp;This creates a True/Flase value.&nbsp; I change the value to text, and wrote an if statment that returns a vaule of Sold or Available.&nbsp; Not ideal - but functional.&nbsp;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?&nbsp;Thanks.

ricardocamargos · Answer

Anonymous,&nbsp;You can create a measure using the EXCEPT function, passing que ID`s.&nbsp;Sold = VAR tbl1 = SELECTCOLUMNS(TABLE_1, "ID")VAR tbl2 = SELECTCOLUMNS(TABLE_2, "ID")VAR tbl = EXCEPT(tbl1; tbl2)RETURN&nbsp; &nbsp; COUNTX(tbl; ID)&nbsp;Using this measure in a table you can visualize if it`s available or not, it will return 0 or non 0;&nbsp;Thanks,&nbsp;Ricardo&nbsp;

Forum Discussion

VOID

5 Replies

Related content

VOID error message in Fabric table SQL endpoint view

Method not found: 'Void Newtonsoft.Json.JsonSerializerSettings..ctor(Newtonsoft.Json.JsonSerializer"

Validate voids in columns with dates

Method not found: 'Void Microsoft.PowerBI.Api.V1.PowerBIClient..ctor(Microsoft.Rest.ServiceClientCre

Get a count of missing/void data