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.
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
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |