Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello.
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
Solved! Go to Solution.
Hi @mohsin-raza
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
[a=Number.RoundTowardZero(([Index]-1)/10),
b=if [Index]=1 then null
else if a =0 then "A"
else if a=1 then "B"
else "Unknown"][b]
Hi @mohsin-raza
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
[a=Number.RoundTowardZero(([Index]-1)/10),
b=if [Index]=1 then null
else if a =0 then "A"
else if a=1 then "B"
else "Unknown"][b]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.