Calculate 1% Decreasing Value of First row against all rows

[Anonymous]

Hi Guys. I am trapped in a problem and have no idea how to solve it. I want to decrease value of first row against every row i.e. In table below value of januray is decreased by 1% against all other months. i want to create a measure of this.

[Anonymous · Accepted solution]

I have done it but in a lengthy way. i created a new table of months with two columns MonthID and MonthName. Then used switch statement to replicate January data decreased by 1% one by one in all other months.

[amitchandak]

@Anonymous , either add an index column. Or if you have date . Try like

New COlumn =

(datediff([date],min([Date],Month) -1)

New COlumn =

[index]- min([index])

[Anonymous]

After creating this index column how do i use it in my measure?