KPI compare values based on FIRSTDATE and LASTDATE

[luke050]

Hi,

I want to put KPI graph for quite simple thing

it will be based on two columns: Date and values for each date

it is important that one date can have several values

this is example

I want to compare the oldest date value with the most recent date value in this KPI in this case 752 vs 854

i have masures:

FirstDate = CALCULATE(MIN(sessions[profiles.followers]),FIRSTDATE(sessions[Date2]))

LastDate = CALCULATE(MAX(sessions[profiles.followers]),LASTDATE(sessions[Date2]))

but i dont know how i can compare it KPI.?

It returns 0 for FirstDate when using in KPI

[v-jingzhang · Accepted solution]

Hi @luke050 

Use below codes for your FirstDate measure.

FirstDate = 
VAR _firstDate = MINX(ALL(sessions),sessions[Date2])
RETURN
CALCULATE(MIN(sessions[profiles.followers]),sessions[Date2]=_firstDate)

In your original measure, FIRSTDATE(sessions[Date2]) performs context conversion and returns the first date in current context. Its current context is each date on the axis Date, so the FirstDate measure returns the minimum value on each date. In your example, there is only a value on the last date, so the maximum value and minimum value is the same and difference percentage is 0.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.