Forum Discussion
Accumulate Measure Calculation to Current Month
Linkk Is your data laid out exactly like shown in the matrix and in Excel? If so, you're doing it wrong.
Power Query unpivot your months into columns and make them actual date values. Any date in a month will work. second, date table! Google the importance of this!
You do those two things and this should be fairly easy with a basic SUM() with category down the side and Month Name (from the date table) across the top.
Thanks for you attention littlemojopuppy! I'm actually using a data table, see:
and the matrix is laid out the way you mentioned, but I didn't mention 'Tabela 2'[Indicadores] is a Table with distinct values of 'Tabela 1'[Indicadores], that's why i'm counting the rows in 'Tabela 1':
I'm using a slicer for the selection of the year, which is considering just the year of 2023 for the images above.
Although I've seen some posts tackling cumulative measure, I wasn't able to translate them for my task at hand.