Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to calculate average value per day each day of the current month ?

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_HOURSTEMPERATURE_1 (°F)
01/10/2020 00:00

54

01/10/2020 08:0053
01/10/2020 15:0056
01/10/2020 23:0054
02/10/2020 00:0056
02/10/2020 08:0055
02/10/2020 15:0057
02/10/2020 23:0054


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 !

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Check the 'Table' in the file attached

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Check the 'Table' in the file attached

Anonymous
Not applicable

@amitchandak Thank you for take time to making this file. It's more clear ! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.