Forum Discussion
Append two tables using left antijoin
workmonitored as a rule of thumb and best practice, do transformation/data preparation as upstream as possible, and as close to the source.
if you can do this in an SQL server then better to do it there so that it can be used for other reports/projects as well instead of doing it in Power BI.
Hope this helps.
workmonitored if that it the case, append both the table and group it get the latest date, here is M code, start a blank query, click advanced editor and paste the code below, change the name of the table in the first line:
let
Source = Table.Combine({All, Open}),
#"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
#"Grouped Rows" = Table.Group(#"Added Index", {"Key", "Description"}, {{"Latest Date", each List.Max([Date Worked On]), type nullable date}})
in
#"Grouped Rows"
Thank you. Should I be worried about doing this in PowerBI and not a sql server. Not sure how performant PowerBI will be. I am guessing that's why there is an index column in there. I am talking about hundred thousand rows and updating 2K of them.
