Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help - Show when data doesnt match

Hi,    Could you please create me a powerbi measure to filtre data to only show sales order numbers where the warehouse doesnt match the po numbers warehouse putting a Y for Mismatched and N for ma...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    you can try this

     

    Column =
    var _w=maxx(FILTER(Purchasing,Purchasing[Purchase order number ]=SalesOrdersItems[PO Number ]&&SalesOrdersItems[Order Number]=Purchasing[Sales Order number ]),Purchasing[Warehouse])
    return if( _w=SalesOrdersItems[Warehouse ],"Y","N")
     
    pls see the attachment below
     
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, I got an error: The syntax for 'return' is incorrect. (DAX(maxx(FILTER(Purchasing,Purchasing[Order Number]=SalesOrdersItems[PO Number]&&SalesOrdersItems[Order Number]=Purchasing[Sales Order No]),Purchasing[Warehouse])return if( _w=SalesOrdersItems[Warehouse],"Y","N"))).

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

I reproduced your error below.

Your problem is that the var definition is missing. After adding "var _w=" and it worked.

Hope it helps.

 

Best Regards,

Stephen Tao

 

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