Forum Discussion

Alopez11's avatar
Alopez11
Regular Visitor
4 years ago

Help with Dax Formula, T°

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!

 

 

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Alopez11 

    please try

    Grados Dias =
SUMX ( Data, VAR Diff = Data[T] - 10 RETURN IF ( Diff > 0, Diff ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.