Forum Discussion
Count moving data
Frost,
I am not clear about that how you calculate the number of activity for each value. In your first example, do you mean that from 09:12:56 to 11:15:50, 17 and 18 active twice?
Regards,
Lydia
18 starts to be active at 09:20:47. At 11:00:03 it moves to "Number2" column, since we get a lower number in "Column1". 18 is still active. 11:00:14 it moves back to "Number1" since 17 has been cleared and dissapeared. 11:15:41 18 is cleared with '0'. 18 ahs therefore been active once during 09:20:47 to 11:15:41.
The second time 18 gets active again is at 11:15:42 in "Number3". Since lower numbers are cleared each step, it moves to "Number1" eventually at 11:15:49 and finally cleared at 11:15:50.
So, during 09:20:47 to 11:15:50, 18 has been active twice, but have been moving around in different columns due to lower values getting active until finally cleared.
Hope this helps...
Frost,
I don't think that we can count the occurence for these values in Power BI Desktop, as the rules to calculate the number are dynamic and different for different values.
Regards,
Lydia
