getting previous value

[Anonymous]

hi all..

perhaps it a silly question but do i get the previous value of a column?

i tried lookup value & earlier but got lost in them.any help.

thank you.

[sanalytics · Accepted solution]

Hey @Anonymous ,

Take this as solution,

you may need a spporting column or Index for this 

supporting col = RANKX('Table',[DIGITS],,ASC)

Then, you calculate previous value by that supporting col..

Previous Value = CALCULATE(FIRSTNONBLANK('Table'[DIGITS],TRUE()),FILTER('Table','Table'[Supporting Col] = EARLIER('Table'[Supporting Col])-1) )

Regards,

Snandy

If this is your solution, Please accept it as solution..It will help others

[sanalytics · Accepted solution]

Hey @Anonymous ,

Take this as solution,

you may need a spporting column or Index for this 

supporting col = RANKX('Table',[DIGITS],,ASC)

Then, you calculate previous value by that supporting col..

Previous Value = CALCULATE(FIRSTNONBLANK('Table'[DIGITS],TRUE()),FILTER('Table','Table'[Supporting Col] = EARLIER('Table'[Supporting Col])-1) )

Regards,

Snandy

If this is your solution, Please accept it as solution..It will help others

[az38]

Hi @Anonymous 

if your data is so simple you could try a column

Column = calculate(LASTNONBLANK(Query[Digits];1);filter(all(Query);Query[Digits]<EARLIER(Query[Digits])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

@az38 @sanalytics 

Thanks, both methods works for me...

1 more question, as i used the previous value to calculate the difference.

my chart (using the diff column) will show as follow.

is there a way not to show the first value..in this case, would be the value 110 in column "Diff"

[az38 · Accepted solution]

@Anonymous 

smth like that

Diff = if(isblank([Previous]); BLANK(); [digits]-[previous])

do not hesitate to give a kudo to useful posts and mark solutions as solution

[sanalytics]

Hey @Anonymous 

Re create your Diff Col.
if(ISBLANK(Prev),Blank(),Diff)

then go tho the visual level filter and deselect the blank from the diff .

Hope it will helps,

Regards,

Snandy