IncidentDimvw

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",{"ResolutionCategory"},IncidentResolutionCategoryvw,{"ID"},"NewColumn"),
    #"Expanded NewColumn3" = Table.ExpandTableColumn(#"Merged Queries3", "NewColumn", {"IncidentResolutionCategoryValue"}, {"NewColumn.IncidentResolutionCategoryValue"}),
    #"Merged Queries4" = Table.NestedJoin(#"Expanded NewColumn3",{"Source"},IncidentSourcevw,{"ID"},"NewColumn"),
    #"Expanded NewColumn4" = Table.ExpandTableColumn(#"Merged Queries4", "NewColumn", {"IncidentSourceValue"}, {"NewColumn.IncidentSourceValue.1"}),
    #"Merged Queries5" = Table.NestedJoin(#"Expanded NewColumn4",{"Status"},IncidentStatusvw,{"ID"},"NewColumn"),
    #"Expanded NewColumn5" = Table.ExpandTableColumn(#"Merged Queries5", "NewColumn", {"IncidentStatusValue"}, {"NewColumn.IncidentStatusValue"}),
    #"Merged Queries6" = Table.NestedJoin(#"Expanded NewColumn5",{"TierQueue"},IncidentTierQueuesvw,{"ID"},"NewColumn"),
    #"Expanded NewColumn6" = Table.ExpandTableColumn(#"Merged Queries6", "NewColumn", {"IncidentTierQueuesValue"}, {"NewColumn.IncidentTierQueuesValue"}),
    #"Merged Queries7" = Table.NestedJoin(#"Expanded NewColumn6",{"Urgency"},IncidentUrgencyvw,{"ID"},"NewColumn"),
    #"Expanded NewColumn7" = Table.ExpandTableColumn(#"Merged Queries7", "NewColumn", {"IncidentUrgencyValue"}, {"NewColumn.IncidentUrgencyValue"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded NewColumn7",{"Classification", "Classification_IncidentClassificationId", "Impact", "ResolutionCategory", "ResolutionCategory_IncidentResolutionCategoryId", "Source", "Source_IncidentSourceId", "SourceId", "Status", "Status_IncidentStatusId", "TierQueue", "TierQueue_IncidentTierQueuesId", "Urgency", "Urgency_IncidentUrgencyId"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"NewColumn.IncidentClassificationValue", "Incident.Classification"}, {"NewColumn.IncidentImpactValue", "Incident.ImpactValue"}, {"NewColumn.IncidentResolutionCategoryValue", "Incident.ResolutionCategory"}, {"NewColumn.IncidentSourceValue.1", "Incident.Source"}, {"NewColumn.IncidentStatusValue", "Incident.Status"}, {"NewColumn.IncidentTierQueuesValue", "Incident.TierQueues"}, {"NewColumn.IncidentUrgencyValue", "Incident.Urgency"}, {"NewColumn.IncidentSourceValue", "Incident.SourceValue"}})
in
    #"Renamed Columns"