return difference between two tables

[dgdgdg122db]

Hello there ,

I have two tables looks like follows:
Table 1 : Online ,   Columns: ProductName, CustomerID, ProductPurchased Date

Table 2 : Offline ,   Columns: ProductName, CustomerID, ProductPurchased Date

I want to get the products that were only pruchased online.  The DAX EXCEPT works fine, if I remove the date column:

onlineonly = EXCEPT(Online,Off)

but now I want to know on which date the product was only pruchased online.

can you please help

[amitchandak · Accepted solution]

@dgdgdg122db , Try anti join in power Query, You can create a combined join column if needed

Append/Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query