Forum Discussion

em101's avatar
em101
Frequent Visitor
2 years ago

Comparing data sets

Hi there  I have been trying to compare two data sets (for example between the month of November and December) in Power BI.     I have included Dropbox links below to basic data that I am trying t...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
let
    Source = Folder.Files("C:\Users\xxx\Downloads"),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "Risk data") and Text.EndsWith([Name], ".xlsx")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Table.PromoteHeaders(Excel.Workbook([Content]){0}[Data], [PromoteAllScalars=true])),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Name", "Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"Residual Risk Rating", "Risk"}, {"Residual Risk Rating", "Risk"})
in
    #"Expanded Custom"