Forum Discussion

GilbertQ's avatar
GilbertQ
Super User
9 years ago
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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    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]))

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

GilbertQ

 

you can try with:

 

FirstDate-Value = CALCULATE(VALUES(Table1[Value]),FIRSTDATE(Table1[Date]))

LastDate-Value = CALCULATE(VALUES(Table1[Value]),LASTDATE(Table1[Date]))

GilbertQ's avatar
GilbertQ
Super User
9 years ago

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]))