Spilt up the blank columns in the other groups

[sams84]

Hello,

I am using a CSV file as my dataset, and I tried to make a group of one of my columns.

But that column has around 6000 blank records, and we decided to split up blank records in those 4 groups by 20% to group 30%, group 2 by 25%, and group 3 by 30%.

Is there any way to have this solution in Power BI?

Example:

Column name Company Location split up into groups (Asia, Europe, America, Africa), but 6000 records are blank, and we want to split up them with the above percentage into those groups.

Thanks

[ppm1]

Probably a few ways to do this. One idea would be to generate a random number on the blank rows and then use thresholds consistent with your weights with nested if then else to assign those values. Since you have 6000 values, it should get close to your desired split.

Pat