Forum Discussion

Mikester_104's avatar
Mikester_104
New Member
6 years ago
Solved

Percentage Grouping Power BI

New to Power BI - need help.

 

I have a very basic calculation that percentage between -100% and 1,000% - I am trying to group these so into a model as i have 13,000 records each with a different percetange.

 

I have already taken my on hand QTY and Set Safety Stock Value and completed the % over or under Safety Stock value. Whcih is hte %.

 

Want to Bucket or Group these into a range:

GroupLowHigh 
Safety Stock Gone-100%-100%anythin that falls between these two %'s add gone to new column
75% of Safety Stock Gone-75%-99% 
50% of Safety Stock Gone-50%-74% 
25% of  Safety Stock Gone-25%-49% 
Just Entered into SS0%-24% 
25% Above Safety Stock1%25% 
50% Above Safety Stock26%50% 
75% Above Safety Stock51%75% 
100% Above Safety Stock76%1000000% 
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Mikester_104 ,

    If I got it correctly, you can create this calculated column using switch() statement:

    Group = 
SWITCH (
    TRUE (),
    'Table'[% into SS] = -1, "Safety Stock Gone",
    'Table'[% into SS] >= -0.99
        && 'Table'[% into SS] <= -0.75, "75% of Safety Stock Gone",
    'Table'[% into SS] >= -0.74
        && 'Table'[% into SS] <= -0.5, "50% of Safety Stock Gone",
    'Table'[% into SS] >= -0.49
        && 'Table'[% into SS] <= -0.25, "25% of Safety Stock Gone",
    'Table'[% into SS] >= -0.24
        && 'Table'[% into SS] <= 0, "Just Entered into SS",
    'Table'[% into SS] >= 0.1
        && 'Table'[% into SS] <= 0.25, "25% Above Safety Stock",
    'Table'[% into SS] >= 0.26
        && 'Table'[% into SS] <= 0.5, "50% Above Safety Stock",
    'Table'[% into SS] >= 0.51
        && 'Table'[% into SS] <= 0.75, "75% Above Safety Stock",
    'Table'[% into SS] >= 0.76
        && 'Table'[% into SS] <= 10000, "100% Above Safety Stock",
    "No corresponded data"
)

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies