Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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.
Hi @Alopez11
please try
Grados Dias =
SUMX ( Data, VAR Diff = Data[T] - 10 RETURN IF ( Diff > 0, Diff ) )
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |