Forum Discussion
Solved
Summarize data into new table
Hello! I'm trying to create a new table from another. Table 1: each row is a date (from 1/1/2014 to today) I need a table that summarizes the data: - New table: each row ...
Hi lmatera,
Do you really need to build another table with value pre calculated ?
You could simply enrich you Power Pivot data model by :
1. adding calculated columns to build and year and month attributes
Year = YEAR([Fecha] YearMonthCode = FORMAT([Fecha],"yyyyMM") YearMonthLabel = FORMAT([Fecha];"yyyyMMM")
2. ordering the column YearMonthLabel by YearMonthCode
3. adding new measures to aggregate your metrics as you want
AveragePrecioPlatts = AVERAGEX('Test',[PrecioPlatts]) AverageEuroToDolar = AVERAGEX('Test',[PrecioPlatts] * [EuroToDolar]) AverageBrentCierre = AVERAGEX('Test';[BrentCierre]And just build you matrix.
Hi lmatera,
Do you really need to build another table with value pre calculated ?
You could simply enrich you Power Pivot data model by :
1. adding calculated columns to build and year and month attributes
Year = YEAR([Fecha] YearMonthCode = FORMAT([Fecha],"yyyyMM") YearMonthLabel = FORMAT([Fecha];"yyyyMMM")
2. ordering the column YearMonthLabel by YearMonthCode
3. adding new measures to aggregate your metrics as you want
AveragePrecioPlatts = AVERAGEX('Test',[PrecioPlatts])
AverageEuroToDolar = AVERAGEX('Test',[PrecioPlatts] * [EuroToDolar])
AverageBrentCierre = AVERAGEX('Test';[BrentCierre]And just build you matrix.
