topic Creating column with value from other date row in DAX Commands and Tips

Creating column with value from other date row

Anonymous — Fri, 13 May 2022 21:27:21 GMT

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!

amitchandak — Sat, 14 May 2022 02:21:04 GMT

Anonymous , Try like

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

Whitewater100 — Sat, 14 May 2022 13:03:38 GMT

Hello:

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

Whitewater100 — Sat, 14 May 2022 13:14:48 GMT

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..