Create indicator (CARD) which shows if average per day is bellow a value during one month - POWER BI

[Anonymous]

Hello everyone,

Please look at my last post which explain my issue.

Thank you,

[amitchandak]

@Anonymous , Not very clear. But in case you want a column. Have columns like these

Date = [DATE HOURS].date
month Year = format([DATE HOURS],"YYYYMM")

New column 1 = if([Temperature ss1] > averageX(filter(Table, [month Year] =earlier([month Year])),[Temperature ss1]),"Yes", "No")
New column 2 = if(averageX(filter(Table, [month Year] =earlier([month Year])),[Temperature ss2]),"Yes", "No")

[Anonymous]

Thank you for your answer.

I'm not very clear sorry, I explain again :

My data :

DATE HOURS	Temperature ss1	Temperature ss2
01/10/2020 00:00	55	56
01/10/2020 08:00	56	40
01/10/2020 15:00	56	46
01/10/2020 23:00	55	55
02/10/2020 00:00	55	55
02/10/2020 08:00	57	54
02/10/2020 15:00	58	48
02/10/2020 23:00	58	49

I have four temperature measurements per day and I would like to know if average temperature per day is below 55°C one time or more during one whole month.

Exemple : if during whole october the daily average temperature_SS1 >55, but the 11th October the daily average temperature <55 ; POWER-BI writes "0" in a measure.

Other exemple : if during all october the daily average temperature_SS1 >55 ; POWER-BI writes "1" in a measure.

I will use this measure in CARD. Thank to that each month I can check if temperature drops bellow 55°C each day.

The CARD will be like :

value = 0 (Not ok)

value = 1 (Ok)

I hope I was clear,

Thank you in advance !

[Anonymous · Accepted solution]

Resolved : look at https://community.powerbi.com/t5/Desktop/How-to-calculate-average-value-per-day-each-day-of-the-curr...