Forum Discussion
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 -...
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"))).
could you pls provide the pbix file?