Heatwave

[RGR]

Hello all, would like to ask for help,

I have two tables:
* date table
* table called total, in this table there is a column 'max.temp.' which contains daily max. temp. since 1951

I would like to visualize the following in a matrix/table.

By year - number of heatwaves - startdate / enddate of this heatwave - duration in days - average temp during this heatwave.
If there are multple heatwaves in one year, show them on different rows in the matrix/table.

(edit 11-6-23!)
A heatwave is a serial of (at least) 5 days in a row where max.temp. >=25 AND within this period there are also 3 days in a row where max.temp. >= 30.

Don't know how to handle this ... columns / meausures / combination??
Any help would be appreciated, thanks in advance.
Best regards, RG

[vanessafvg]

do you have some sample data or your pbix to share?

[RGR]

total-test 

Hello @vanessafvg thanks for your reply. Hope link above will do ...
The last column (with heatwaves) I added manualy in this excel file. It is not in my original data set.