Forum Discussion

kalspiros's avatar
kalspiros
Helper I
5 years ago
Solved

Earliest values based on timeline

Hi All,   i think that can be solved with a CALCULATETABLE that will filter the sliced data and then return the EARLIEST but not too savvy with such sets, plus, from my research on this forum, i di...
  • AlB's avatar
    AlB
    5 years ago

    kalspiros 

    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 

     

AlB's avatar
AlB
Community Champion
5 years ago

kalspiros 

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 

 

kalspiros's avatar
kalspiros
Helper I
5 years ago

Hey AIB,

 

After several issues and tiny amendments on other slicers and filters, that now does the trick!

Glad that VAR is working in Excel as well (wasn't on BI environment) as i did try it in the past to no avail.

All in all, many thanks for your help on this and for opening the VAR unlimeted possibilites for me!

 

Kind Regards