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
hnguy71's avatar
hnguy71
Super User
1 year ago

Hi Anonymous ,

To create a table that shows all the orders that does not match:

Table = CALCULATETABLE(VALUES(SaleseOrder[SaleseOrderNumber]), ISBLANK(Purshasing[OrderNumber]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi That doesnt show if the warehouses dont match. 

     

    I want it to show Sale order Numbers where the purchase order number has a warehouse that doesnt match the sales order ; 

     

    Sales Order 223454 - Warehouse ABC -> is matched to --> Purchase order 2345 - Warehouse xyz (so it would pick this up)

    • hnguy71's avatar
      hnguy71
      Super User
      1 year ago

      Hi Anonymous ,

      Then you would need to do the opposite. The DAX formula is essentially correct:

      Table = CALCULATETABLE(VALUES(Purshasing[OrderNumber]), ISBLANK(SaleseOrder[SaleseOrderNumber]))

       
      Without enough information or sample data, this is as much assistance as I can offer you.