Need to grab the first value of a column sorted by date

[Anonymous]

Hey everone, 

I have a requirement where I need to take the first value of the count column (not minimum or sum).

For e.g. I have dummy data below where the slicer is from 1/1/2020. I need to be able to take the first "From_Count" on the row when sorted by that specific date.

In this scenario the calculation would take the count 203 as that is the first value of the table sorted by the date.

Can anyone help?

I tried creating

CALCULATE(sum(CRCT_METER_CNT[From_Count]), FILTER(CV_BW_DIM_DATE,CV_BW_DIM_DATE[DATE] = [FROM_DATE_FROM_SLICER]))

however the measure is giving me a value of 2466 and not 203.

[amitchandak · Accepted solution]

@Anonymous 

Not sure of the calculation [FROM_DATE_FROM_SLICER]. You can use min or max or slicer date and create a formula like

Measure =
var _max = maxx(Date,Date[Date])// [FROM_DATE_FROM_SLICER], use min or mex

CALCULATE(sum(CRCT_METER_CNT[From_Count]), FILTER(CV_BW_DIM_DATE,CV_BW_DIM_DATE[DATE] =_max ))