Forum Discussion

strachi's avatar
strachi
Regular Visitor
8 years ago

Moving average over non-numeric values (correct errors, fill missing values)

Hi, how can I smooth string values in a column?   I have time series data (timestamp; string) with some errors or gaps in it:   timestamp;string 1521585642;a 1521585643;a 1521585644; 1521585...
strachi's avatar
strachi
Regular Visitor
8 years ago

 

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:

 

https://community.powerbi.com/t5/Desktop/How-to-obtain-the-most-common-value-from-a-column-and-display-it/m-p/170684/highlight/false#M74517

 

Most Frequent String = 
FIRSTNONBLANK (
    TOPN (
        1; 
        VALUES ( Table1[string] ); 
        RANKX( ALL( Table1[string] ); COUNTROWS(Table1);;ASC)
    ); 
    1 
)

Anyone?