Today-1 data for each record

[Anonymous]

Hi All,

I have two columns date and values. I would like to generate a new column which will show previous days values. How can i achieve that?

Thanks and Regards

[v-diye-msft · Accepted solution]

Hi @Anonymous 

This could help:

Measure 3 = CALCULATE(MAX(Table1[Values]),FILTER(ALL(Table1),[Date]=MAX(Table1[Date])-1))

 

[Anonymous]

Hi @v-diye-msft 

Can we achieve this via Calculated Column instead of Measure?

Regards,

Prakash

[Nathaniel_C]

@Anonymous ,

Try this:

Yesterday = 
var _cdate = MAX('Table'[date])
var _calc = Calculate(MAX('Table'[values]),ALL('Table'),'Table'[date]<_cdate)

return _calc

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel 

[Anonymous]

Dear @Anonymous 

I hope the following link will help you 

https://community.powerbi.com/t5/Desktop/Previous-date-values/td-p/134347

Regards, 

Munna