Forum Discussion

Sushree_12's avatar
Sushree_12
Frequent Visitor
7 years ago
Solved

Not Exists function in Power BI

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!

 

 

 

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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.