CODEWITHSUNDEEP
group-bypowerbipowerquery
Anna Khan
Anna Khan

Reputation: 39

Index column based on value/category

I would like to create a new index column in power bi. The index column already refers to the tour level. The second index (e.g. Index.1) should refer to the time of the respective tour. So if index =1 and column date_stop_order = 09/16/2022 07:19 then index.1 =1, if index = 1 and column date_stop_order = 09/16/2022 07:34 then index.1 = 2... and so on. If Index = 2 then Index.1 should start again from new 1. enter image description here

Upvotes: 0

Views: 1776

Answers (1)

horseyride
horseyride

Reputation: 21298

Click select first and second columns. Right click group by and use operation all data. Add index. Expand data

Upvotes: 3

Related Questions