Help with Dax Formula, T°

[Alopez11]

Hello, I'm Agustin Lopez working in the Avocado Industry.
I need a little help with a dax formula that is annoying me.

In Agriculture we use a concept called "Grados dias" in Spanish, it's how much heat or warm our plants receive daily.
In a fast resume its the average daily t°  minus a base t°, for avocado is 10°C.

I have the following data set

And i need to make the following,
The "Grados Dias" it's a daily number and I need to get the number for the hole month.

If the average T° is lower than 10, I can't have negatives "Grados Dias" so we put a 0 on that number (see red color in table)

 

Very apreciate for the help
Thanks!

[Anonymous]

Hi @Alopez11 

How did you get the average value ? Can you provide your sample data and the formula of the average value ? 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

Hi @Alopez11 

please try

Grados Dias =
SUMX ( Data, VAR Diff = Data[T] - 10 RETURN IF ( Diff > 0, Diff ) )