Hi everyone,
I would like to create a measure which shows if a average temperature per day drops below 55 one time or more during one whole month.
These is my datas :
| DATE_HOURS | TEMPERATURE_1 (°F) |
| 01/10/2020 00:00 | 54 |
| 01/10/2020 08:00 | 53 |
| 01/10/2020 15:00 | 56 |
| 01/10/2020 23:00 | 54 |
| 02/10/2020 00:00 | 56 |
| 02/10/2020 08:00 | 55 |
| 02/10/2020 15:00 | 57 |
| 02/10/2020 23:00 | 54 |
I have four temperature measurements per day and I want to know if the average temperature per day is below 55°F one time or more during one whole month.
Exemple : if during whole october the daily average temperature_1 >55°F, but the 11th October the daily average temperature <55°F ; POWER-BI writes "0" in a measure.
Other exemple : if during all october the daily average temperature_1 >55°F ; POWER-BI writes "1" in a measure.
I hope I was clear,
Thank you in advance !
