Forum Discussion
Helper IEarliest values based on timeline
I'd misread. Then use that earliers date to apply it to your measure:
New measure = VAR date_ = CALCULATE ( MIN ( DateTable[Date] ), ALLSELECTED ( DateTable[Date] ) ) RETURN CALCULATE ( [fx Average Value], DateTable[Date] = date_ )If this doesn't work share the pbix
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Community ChampionHi kalspiros
EARLIEST does not have anything to do with this but rather with nested row contexts. Check it out: https://dax.guide/earliest/
Try
CALCULATE ( MIN ( DateTable[Date] ), ALLSELECTED ( DateTable[Date] ) )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
- kalspiros
Many thanks AIB for your reply,
Even though the measure above does succesfully provide the first date of the slicer, i would be actually looking for it to return the [fx Average Value] on the first date of the slicer.
Let me provide some more context: i want to collapse all lines to zero on the first date of the slicer. i don't want these lines to eternally increase in the years to come. in a way, i want to benchmark these lines based on the desired start date. that is why the value on the earliest date is important so that i'll subtract it from my [fn Average Value]
Hope that helps!
Kind Regards
