Forum Discussion

Anonymous

Not applicable

8 years ago

VOID

...

Tips and Tricks

ricardocamargos

Continued Contributor

8 years ago

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

Anonymous
Not applicable
8 years ago
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.

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
  Continued Contributor
  8 years ago
  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
  - Anonymous
    Not applicable
    8 years ago
    ricardocamargos
    
    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.