Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 !
Solved! Go to Solution.
@Anonymous , Check the 'Table' in the file attached
@Anonymous , Check the 'Table' in the file attached
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |