Forum Discussion
Dynamic Min and Max Date Field Based on Values From Slicer Selection
I am trying to get the first score, and the last score based on the dates selected in slicer. I created a date table with DAX and joined to this table one to many, then created a measure to get the m...
AlB
Community Champion
Community ChampionHi Anonymous
Can you provide an example based on the dat you show wit the expected result?
Where/how would you want to use that measure?
The relationship is between which cilumns exactly??
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
I am joining Dates[Date] to Query1[DOS] --(Date of Service)
I would be using the measures in cards and pivot them to put on bar chart as a single value, always the average of total. Just need the inital and final scores never aggregated