Forum Discussion
Power BI data Cleaning verify data point value has increased over last data point.
I have multiple data points that are totalized values, at times there is times a data is missed. I am trying to find a way to verify that each data point is greater than the one prior and then if missing data point is found, the data point is corrected by taking the next good reading and the prior good reading and then dividing the value by the number of missed points to get the change each data point and adding this to the prior good point to fill in the missing data. There is 3 data fields that would have to be used in the data point classification. Date, name and value. There are multiple Names in the name column.
I have been looking at R and the Library MICE to do this, but cannot figure it out.
2 Replies
- v-xuding-msftCommunity Support
Hi moltra ,
Not clearly about your requirement. Can you please share some sample data and expected results?
- moltraHelper IV
Date Time
Name Value 6/24/2020 07:00:00 Datapoint1 1000 6/24/2020 08:00:00 Datapoint1 1010 6/24/2020 09:00:00 Datapoint1 1025 6/24/2020 10:00:00 Datapoint1 0 6/24/2020 11:00:00 Datapoint1 1045 6/24/2020 12:00:00 Datapoint1 1057 6/24/2020 13:00:00 Datapoint1 1069 I m trying to figure out a way for Power BI to fix the missing / incorrect datapoint at time 6/24/2020 10:00:00. What I would like to happen would be that it takes the change and divides it by the period to get the time change per period and then it adds it to the last good reading.
1045-1025 = 20
20/2 = 10
1025 + 10 = 1035
the missing datapoint is 1035 and I want to place that in the table in the value point for the affected Date time.