Not Exists function in Power BI

[Sushree_12]

Hi ,

I need a help in getting the User information who are all not placing an order.

I have an Order table which have the User information who have placed  Order for all Dates and a complete list of all the users available for the organization in the user table.

I want to get the users who haven't place an order for the selecting months by comparing the user  information in Orders table with total user information in users table. 

I am trying to create a table which should have a list of user who haven't placed an order  for the data range in Orders table.

Kindly help me in getting the data

Thanks!

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[v-yuta-msft · Accepted solution]

@Sushree_12 ,

You can create a new table using DAX below:

Output = 
VAR Temp_Table_1 = CROSSJOIN(SUMMARIZE(Ordertable, Ordertable[Date]), UserTable)
VAR Temp_Table_2 = SUMMARIZE(Ordertable, Ordertable[Date], Ordertable[UserEmail])
RETURN
EXCEPT(Temp_Table_1, Temp_Table_2)

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.