QTD to Quater

[Anonymous]

Hi everyone!

I have QTD values in my table:

1 quater: 2

2 quater: 5

3 quater: 21

4 quater: 50

But it's cumulative values. So I'm trying trasform QTD to Quater values. And i want to get this:

1 quater: 2

2 quater: 3

3 quater: 16

4 quater: 29

Is there a way to do this?

Thanks,

Sava

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

I have rebuilt a data sample like this:

You could use the following formula to create a measure or column:

Measure = MAX('Table'[QTD])- CALCULATE(MAX('Table'[QTD]),FILTER(ALL('Table'),'Table'[Index]=MAX('Table'[Index])-1))

Column = [QTD]- CALCULATE(MAX('Table'[QTD]),FILTER('Table','Table'[Index]=EARLIER('Table'[Index])-1))

The final output is shown below:

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

[AllisonKennedy]

@Anonymous  yes this can be done. You will need to create a calculated column in the table and use variables or EARLIER function to get the value from the previous quarter. Do you have an index or unique ID in your table? What does the raw data look like?