Forum Discussion
Creating column with value from other date row
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!
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
Super User
Super UserAnonymous , Try like
Last day Qty = sumx(filter(Table, [Shared] = earlier([Shared]) && [Date] = earlier([Date]) -1),[Qty])