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
     
ryan_mayu's avatar
ryan_mayu
Super User
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.

       

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      1 year ago

      could you pls provide your pbix file?