Creating column with value from other date row

[Parfonov]

Hi!

Can you please help with DAX query

I need to paste Qty from yesturday to new column against today date

I mean add column with yesturday Qty for each SEG

Thank you!

[Whitewater100]

ne note - I was using Table Name of data. You can use your table name of AC, so replace "data" in formulas with AC, the name of your table. Thanks..

[Whitewater100 · Accepted solution]

Hello:

Please see attached filed with solve with calc column and measure. I hope this helps!

https://drive.google.com/file/d/1mih9EiAmzLSP10NGmlOk5nmXhpqZwgpv/view?usp=sharing

[amitchandak]

@Parfonov , Try like

Last day Qty = sumx(filter(Table, [Shared] = earlier([Shared]) && [Date] = earlier([Date]) -1),[Qty])