Rollup value for groups of text

[jfreyes]

Hi,

I've tried to find a way to solve the following without success.

I need to calculate rollup values for any given 4 qtr period. Periods are formated in text (e.g. 2019-1, 2019-2..). Grouping isn't an option since Powerbi only allows to use values only in one group, thus the 4 quarter rolloup would not be feasible.

This is a visual sample of the table:

Period        Value

2019-2      $5

2019-2      $35

2019-1      $13

2018-3      $22

2018-4      $17

2018-4      $3

2018-4      $9

Where the 4qtr period ending in 2019-2 would be = the sum value of 2019-2+ sum value of 2019-1 + sum value of 2018-4+ sum value of 2018-3.

Any insight will be appreciated.

Jose

[Icey · Accepted solution]

Hi @jfreyes ,

This is my PBIX file. 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[natabird3]

As far as i understood, this is what you try to achieve:

Create a measure and use this dax code:

Value average per Period =

SUMX(

    KEEPFILTERS(VALUES('Table'[Period       ])),

    CALCULATE(SUM('Table'[Value]))

)