Forum Discussion
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...
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
hi Anonymous ,
for "relationship between SaleOrderItems; PO Number and Purchasing: Order Number.", which is one side?