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
Super 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

thank you- how would i merge the two tables? and what is the expanded purchasing?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    You are welcome.  I have already shared the M code with you.