Forum Discussion
Solved
Get First and Last Values from Table
I was wondering if someone would help me with the following. I have a table that has got Dates and the Amount. What I want to return is the first and last date, with the corresponding (or ass...
Hi there
Thanks for that what I did was the following solution which worked for me due to having using a Date Table, which ensured that I got the last actual value and first actual value.
Sales YOY - First Date = CALCULATE([Sales],FIRSTNONBLANK('Date'[Fiscal Year],'Sales Year on Year'[TSales]))
Sales YOY - Last Date = CALCULATE([Sales],LASTNONBLANK('Date'[Fiscal Year],'Sales Year on Year'[TSales]))
