I need pick past year december Amounts and current year latest month amount value by using dax measure. Please find the screenshot below. I need dax measure for Result column.
Go to Solution.
Have year column or use date table and have year there
Year = year([date])
A measure like
Calculate( lastnonblankvalue(Table[Date]), Sum(Table[Amount]) , Allexcept(Table, Table[Year]))
check if needed https://youtu.be/yPQ9UV37LOU
View solution in original post
Thank you for the code. it works fine and the video reference also very helpful to learn new things. Rock it.
Hi @Jihwan_Kim , @amitchandak
Pls help me on this.
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!