Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
do you have some sample data or your pbix to share?
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |