I ran into a situation in power query as follows:
I have two queries to merge by the columns of "AM" and "Jahr.Monat". The values in the result table will be mixed after
using Table.ExpandTableColumn function. Super easy.
This is the Query "IST":

This is the Query "PLAN":

After merging them together, seems still to be ok, but after expanding the table the values of Column "Ist Kumm" seem to be wrong or mixed.
The M-code for the merge and expand looks like this:
This is the merged query looks like:

After the first step (Quelle) are the values still ok, but after expanding the column I get this red marked values, which are false.
Any idea? Can it be a problem of power query?
I would be very glad to get any hints of tips.
Thank you guys.
I have two queries to merge by the columns of "AM" and "Jahr.Monat". The values in the result table will be mixed after
using Table.ExpandTableColumn function. Super easy.
This is the Query "IST":

This is the Query "PLAN":

After merging them together, seems still to be ok, but after expanding the table the values of Column "Ist Kumm" seem to be wrong or mixed.
The M-code for the merge and expand looks like this:
let
Quelle = Table.NestedJoin(IST2, {"AM", "Jahr.Monat"}, PLAN2, {"AM", "Jahr.Monat"}, "PLAN2", JoinKind.LeftOuter),
#"Erweiterte PLAN2" = Table.ExpandTableColumn(Quelle, "PLAN2", {"PLAN", "PLAN Kumm"}, {"PLAN", "PLAN Kumm"}),
#"Sortierte Zeilen" = Table.Sort(#"Erweiterte PLAN2",{{"AM", Order.Ascending}, {"Jahr.Monat", Order.Ascending}})
in
#"Sortierte Zeilen"
This is the merged query looks like:

After the first step (Quelle) are the values still ok, but after expanding the column I get this red marked values, which are false.
Any idea? Can it be a problem of power query?
I would be very glad to get any hints of tips.
Thank you guys.