Forum Discussion
Grouping based on latest date
I have this table, make like this: let
Source = Sql.Database("mantleanalytics.database.windows.net", "Hevold_Dev"),
dbo_rate_oslo_all = Source{[Schema="dbo",Item="rate_oslo_all"...
Grouping your data is a good thing to do if you only need summarized data; however, pivoting is usually not a good practice for analysis. Leave it unpivoted for easiest analysis, and pivot it in a matrix (by putting the date column on columns) when needed.
Pat
I totally agree! However this is for presenting the data for a department. For analysis i usally work this other programs like python databases, but this department wants an excel file to acess the information
