Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there, I'd very much appreciate some help with the following scenario.
The table/chart below shows readings taken from a digital readout on a water filter over a period of several weeks (note: the interval between readings can vary - it is not always 14 days).
I'd like to use these readings:
A/ to predict when "readingValue" will hit 0
B/ to trigger a power automate flow when it hits a set value (ie. "readingValue" hits is less than 200 litres remaining)
Here's a table showing the sample values above:
readingDate | readingValue | readingDifference | priorSessionreading | numberDaysbetween |
9/02/20 0:00 | 2555 | 0 | ||
9/16/20 0:00 | 2027 | -528 | 2555 | 14 |
9/30/20 0:00 | 1591 | -436 | 2027 | 14 |
10/14/20 0:00 | 1142 | -449 | 1591 | 14 |
Any help would be greatly appreciated.
Thanks,
Greg
Solved! Go to Solution.
@gdbaerg so there are two parts to your problem.
First of all we will create a column to rank readingdate this will be used in our calculation
1. To predict in how many days reading value will be zero. You can use below measure to predict in how many days reading value will be zero.
Proud to be a Super User!
@gdbaerg Sorry I missed something yes we need to create one calculated column like below
Proud to be a Super User!
@gdbaerg so there are two parts to your problem.
First of all we will create a column to rank readingdate this will be used in our calculation
1. To predict in how many days reading value will be zero. You can use below measure to predict in how many days reading value will be zero.
Proud to be a Super User!
Thanks a lot for the help @negi007. How did you define the Rank_date field in your measure?
@gdbaerg Sorry I missed something yes we need to create one calculated column like below
Proud to be a Super User!
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |