Forum Discussion
DAX Filter on dates
Hello noob BI user here, I have a large table with a set of dates and reliated market values. I have a slicer set up which allows the user to set the time period they want to analyse the data ove...
Nathaniel_C
Community Champion
Community ChampionHi Anonymous ,
Is this what you are looking for? I did note that one date was duplicated which I changed as I did not think we could have two market values on same date.
First date = FIRSTDATE(markv[Date])
Last Date = LASTDATE(markv[Date])
Market Value First Date = CALCULATE(MAX(markv[MV]),FILTER(markv,MIN(markv[Date])=[First date]))
Market Value Last date = CALCULATE(MAX(markv[MV]),FILTER(markv,MAX(markv[Date])=[Last Date]))
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel