I want to add new column.
The values in the column based rows.
for exemple from R2 to R10 column values are "A" ,from R11 to R20,Values in column are "B" and so on
Go to Solution.
You can utilize Index column, one way to do, if you have a lot of values to add according to the Index, you can utilize a custom function like switch
b=if [Index]=1 then null
else if a =0 then "A"
else if a=1 then "B"
View solution in original post
Thanks @Vera_33 for your nice help.It works .
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!