Challenging Dashboard, frost damage

Lopez1234R — Thu, 20 Apr 2023 19:11:49 GMT

Hello,

I'm trying to make a dashboard that doesn't have any database on it, they are just inputs of that from the user and we retrieve some information.

Is not that difficult, but I'm unable to make it. I will attach an excel that explain also what I'm attempting to do.

We are trying to make a dashboard that make a forecast of posible frost damage on fruit trees. We are searching when the temperature is below 0°C.

For that we just need the following information
Temperature and Huimidity.

The rules are the following.

At any specific time given (Variable Time), the user have to input the Temperature and the Humidity of a sensor.
Then the dashboard make the following calculation.

1- Calculate the Dew Point(Pr) Formula is (notice that the root is at the 8 level)

2- For every houre that the T° is > than Pr, the next hour (forecast) you have to lower on -1,2°C the forecasted T°. In the case that T° is <= than Pr, you have to lower -0,4°C to the forcast of the next hours.

3- Also, notice that the Pr forecast will be lowered by -0,1 each hour.

4- The T° is going to be lowering until 7:00am

So with that infomation we are able to build on excel the following.

On green, the data that the user adds.
On yellow, the moment when T° is = or Lower to Pr and the T° forecast change from -1,2°C to -0,4°C

I was thinking to make it with Parameters, where the user can move the with a slicer the T° and the Humidity.

Thanks for everything
And waiting for the guy how is able to make this!

topic Challenging Dashboard, frost damage in DAX Commands and Tips

Challenging Dashboard, frost damage