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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

This M code works

let
    Source = Table.NestedJoin(Salesorder, {"Sales Order number "}, purchasing, {"Sales Order number "}, "purchasing", JoinKind.LeftOuter),
    #"Expanded purchasing" = Table.ExpandTableColumn(Source, "purchasing", {"Warehouse"}, {"Warehouse1"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded purchasing", each ([#"Warehouse "] <> [Warehouse1]))
in
    #"Filtered Rows"

Hope this helps.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi This is what i got : 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    My code has to be pasted in the Advanced Editor window which is available under View.  Ensure that the table and column names in your actual file are the same as those which are in the M code which i shared.