Make dynamic index based on multiply conditions

[MichaelThomsen94]

Hello Alteryx,

I have a problem i hope you guys can help me solve. 
My goal is to create an index column E, based on column C ("Count") in the attached Excel file, for each "Kommune" in column A.

Btw column E is manual made in Excel for the demonstration purpose.. which is also the end goal.

The target is that the row corresponding to the value "01-03-2022", is index 100 and the rest of year is based around it. 

[Christina_H · Accepted solution]

You just need to filter out your target rows and join the target onto all rows (join on Kommune).  Only a problem if the target date doesn't exist for one of them.

[MichaelThomsen94]

Thank you for the help Christina_H it worked! :)