Forum Discussion
Moving average over non-numeric values (correct errors, fill missing values)
Hi strachi,
Can you share a complete sample please? I can't convert the "timestamp" into a time or a date.
Best Regards,
Dale
Hi v-jiascu-msft, thanks for your reply.
In fact we can further simplify. The "timestamp" does not matter here. The first column is just to indicate the order of the timeseries data. Your can think of it as an ordered index.
Source:
timestamp;string
1;a
2;a
3;(blank)
4;a
5;a
6;x
7;a
8;a
9;a
Result I am looking for:
timestamp;string
1;a
2;a
3;a
4;a
5;a
6;a
7;a
8;a
9;a
The "blank" and the "x" are errors to be identified by looking at the previous and following values in the series. They should be replaced by the most frequent value "in the neighbourhood".
Thank you for giving it another thought.
Sorry to push here... any ideas? v-jiascu-msft
I am trying to use this to narrow down the strings in proximity to the data gap...
FILTER(Table1;Table1[Index]<=EARLIER(Table1[Index])+1 && Table1[Index]>=EARLIER(Table1[Index])-1)
I guess this could help me I do not succeed in putting it together in a calculated column:
Most Frequent String = FIRSTNONBLANK ( TOPN ( 1; VALUES ( Table1[string] ); RANKX( ALL( Table1[string] ); COUNTROWS(Table1);;ASC) ); 1 )Anyone?
