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 .
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!