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 ...
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.

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.