Forum Discussion
All Time High and Low based on multiple Fields and Date
Hello all: I am trying to figure out how to get an ATH measure based on a couple of fields. BAsiclaly the data is structured like below (with many other columns, but not of concern), and I'd like...
SpartaBI
Community Champion
Community ChampionAnonymous maybe more info is required in case total is a column in your table then try this:
Set 1 ATH = CALCULATE(MAX('Table'[Total]), REMOVEFILTER('Table'), VALUES('Table'[Set])
Set 1 ATL = CALCULATE(MIN('Table'[Total]), REMOVEFILTER('Table'), VALUES('Table'[Set])
Thank you for the response. I think I can provide some extra information:
What I'm looking for it to do is compare the Totals for each date and then return which of those was highest.
It would therefor have to SUM up the totals by Date for all different Variety (per each date) and then return whichever one was highest.
So would SUM Green, Red, and Blue for 1/5/2022 and compare to the SUM of Green, Red, and Blue for 2/5/2022.
- SpartaBI
Anonymous I will PM you