Matrix, calculate expression in different periods of time in columns

[pratafran]

Hello!,

I have an expression (let's say SUM(Sales[Qty])) that I want to put into a matrix, but I want to evaluate different periods of time in columns.

For Example, calculating the sum of sales cummulated, last quarter, last month and last 6 weeks.

Sales	YTD	Last Quarter	Last Month	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
Qty	21000	7500	3000	800	700	400	600	1000	900

I can generate a measure for each of them with CALCULATE ( SUM(Sales[Qty]), FILTER(Calendar, Date = XXXX)) but I would like to avoid creating too many measures.

Is it possible, to generate a measure with multiple results? and expose those into columns in a matrix?. For example, defining each measure into variables (VAR) but allowing multiple RETURN. Any other approach to avoid multiple measure creation is also a possibility.

Thanks

[Anonymous · Accepted solution]

Hi,

I think maybe calculation groups may work for you:

REDUCE the # of measures with Calculation Groups In Power BI - YouTube

[pratafran]

thank you, that is exactly what I was looking for.

The only thing that I think is not possible is to dynimically change the name of the measure depending on the content (for example for the las 6 weeks, each column to show the number of each in the column name).