Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

DAX Formula - Mismatch

Hi,    Could you please create a DAX formula that shows SalesOrders that have a warehouse that doesnt match Purchasing warehouse.   the tables i have are:    SalesOrder : - SalesOrderNumber -...
General Comment
Need Help
Tutorial Requests
ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

Anonymous 

you can try to create a column

 

Column =
VAR _w=maxx(FILTER(Purchasing,Purchasing[Purchase order number ]=SalesOrder[Purchase Order Number ]),Purchasing[Warehouse])
return if(_w<>SalesOrder[Warehouse ],"y")
 
pls see the attachment below
 
 
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you, however it says : The syntax for 'return' is incorrect. (DAX(maxx(FILTER(Purchasing,Purchasing[Purchase order number ]=SalesOrder[Purchase Order Number ]),Purchasing[Warehouse])return if(_w<>SalesOrder[Warehouse ],"y"))).

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    could you pls provide the pbix file?