Forum Discussion
Index according to value
Hello,
I am trying to create different index groups depending on the Value and the Hours columns. To better understand I added an example.
Initial Table:
Initial data.
So I used Power Query to group by Tag and Value and got the following. My goal is to count or index repeated numbers if there is only 1 hour of difference between measurements, like shown in green column.
Groups
Really appreciate any help with this! I've already tried grouping in different ways, or using Dax, and many other possibilities, but nothing reached this goal...
Anonymous
pls see the attachment below
18 Replies
ryan_mayuSuper User
why tag 1 ,12:00:00 is not between the 11:00 and 13:00?
why it is in the end of tag 1?
should the date of that row be 02/01/2022?
- ryan_mayu
here is a workaround for you. pls see the attachment below
Thanks a lot for sharing this information. I am going to implement this thing on my website's data that is related to Atlanta DUI attorney. If I face any issue then I will let you know.
