Forum Discussion

SG25048519's avatar
SG25048519
Frequent Visitor
4 years ago
Solved

Sales Bucket in Power BI

Hello, I need some help in creating a sales bucket based on company. I have 11,000 companies and have summed up all the sales value based on each company and now want to bucket them under the foll...
Need Help
  • SG25048519's avatar
    SG25048519
    4 years ago

    Thank you very much. I will try to use both and update you. Once again, thank you.

     

serpiva64's avatar
serpiva64
Solution Sage
4 years ago

Hi,

please check your formula because there is an error:

SWITCH (

    TRUE (),

    [Sales Value] >= 0

        && [Sales Value] <= 1000, "0-1000",

    [Sales Value] > 1001

        && [Sales Value] <= 2000, "1001-2000",

    [Sales Value] > 2001

            && [Sales Value] <= 50000, "2001-5000",

    [Sales Value] > 5001

            && [Sales Value] <= 10000, "5001-10000",

    [Sales Value] > 10001

            && [Sales Value] <= 50000, "10001-50000",

        [Sales Value] > 50000, "50000+"

 

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution !

  • SG25048519's avatar
    SG25048519
    Frequent Visitor
    4 years ago

    Thank you for flagging, I was just giving an example, the original measure is also posted here, which I used.