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

ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

could you pls provide your pbix file?