Filtering Max/ Min by a set of dates

[Dannyd104]

Hello everyone,

I am relatively new to Power BI and am still learning DAX.

I am currently pulling in data from a website which gives me the temperature of a specific area five days out. The data gives multiple temperatures per day (one every 3 hours or so). Right now I am trying to build measures to get the MAX and MIN of the temperatures per day, but am struggling to come up with the formulas. 

I currently have the following formula:

MAXVALUEDATE=CALCULATE(MAX)[Temp]),FILTER(Forecast,[DATE]))) and it is only giving me the Max value for all the dates that are imported.

[Anushka · Accepted solution]

Hi,

You can get a summarized table using this,

Table = GROUPBY(Forecast

                           ,Forecast[Date]

                           ,"MaxTemp",MAXX(CURRENTGROUP(),Forecast[Temp])

                           ,"MinTemp",MINX(CURRENTGROUP(),Forecast[Temp])

                           )

[Dannyd104]

Thank you very much!

I had not considered the approach of making a new table, but it summarizes everything perfectly.