Forum Discussion

abh1abh's avatar
abh1abh
Frequent Visitor
3 years ago

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"...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

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