Theknall

let
    Source = Sql.Database("db05", "DWDataMart"),
    dbo_IncidentDimvw = Source{[Schema="dbo",Item="IncidentDimvw"]}[Data],
    #"Merged Queries" = Table.NestedJoin(dbo_IncidentDimvw,{"Classification_IncidentClassificationId"},IncidentClassificationvw,{"IncidentClassificationId"},"NewColumn",JoinKind.LeftOuter),
    #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"IncidentClassificationValue"}, {"NewColumn.IncidentClassificationValue"})
in
    #"Expanded NewColumn"

Theknall

let
    Source = Sql.Database("DB05", "DWDataMart"),
    dbo_IncidentDimvw = Source{[Schema="dbo",Item="IncidentDimvw"]}[Data],
    #"Merged Queries" = Table.NestedJoin(dbo_IncidentDimvw,{"Classification"},IncidentClassificationvw,{"ID"},"NewColumn"),
    #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"IncidentClassificationValue"}, {"NewColumn.IncidentClassificationValue"}),
    #"Merged Queries1" = Table.NestedJoin(#"Expanded NewColumn",{"Impact"},IncidentImpactvw,{"ID"},"NewColumn"),
    #"Expanded NewColumn1" = Table.ExpandTableColumn(#"Merged Queries1", "NewColumn", {"IncidentImpactValue"}, {"NewColumn.IncidentImpactValue"}),
    #"Merged Queries2" = Table.NestedJoin(#"Expanded NewColumn1",{"LastModifiedSource"},IncidentSourcevw,{"ID"},"NewColumn"),
    #"Expanded NewColumn2" = Table.ExpandTableColumn(#"Merged Queries2", "NewColumn", {"IncidentSourceValue"}, {"NewColumn.IncidentSourceValue"}),
    #"Merged Queries3" = Table.NestedJoin(#"Expanded NewColumn2",{"ResolutionC