show Non match data

Naveennegi119 Please try “Merge Queries” option in “Power Query Editor” using appropriate Join as required.

Let me know if you need more detailed.

Hi,

This is the Ma Query i used

let
    Source = Table.NestedJoin(All_months,{"All"},criteria_months,{"Months"},"criteria_months",JoinKind.LeftOuter),
    #"Expanded criteria_months" = Table.ExpandTableColumn(Source, "criteria_months", {"Months"}, {"Months"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded criteria_months", each ([Months] = null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Months"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"All", "Months"}})
in
    #"Renamed Columns"

Hope this heps.

Naveennegi119

Hi , as someone mentioned previously, please use Edit Queries and Merge Queries

Hi,

You can achieve the result in two ways.

Method 1: Merge Queries as New

let
    Source = Table.NestedJoin(Table1,{"Column A"},Table2,{"Column B"},"Table2",JoinKind.LeftAnti)
in
    Source

Method 2: Have Fun with DAX

Create a calculated table using the following expression

Table3 = NATURALLEFTOUTERJOIN(Table1,Table2)

Then filter the calculated table using the following expression

FILTER(Table3,ISBLANK(Table3[Column B]))

Thanks

Hi Naveennegi119,

Here we can create a calculated table using the formula.

Table =
CALCULATETABLE (
    Table1,
    FILTER (
        Table1,
        LOOKUPVALUE ( Table2[Column B], Table2[Column B], Table1[ColumnA] ) = BLANK ()
    )
)

For more details, please check the pbix as attached.

Regards,

Frank