Forum Discussion

LeRuyet's avatar
LeRuyet
New Member
1 year ago

Issue of function Dax Ceiling

Hi    We have a CRM dataset from Kaggle for our first Power BI report, which includes a revenue column for opportunities that we want to categorize into three groups: small, medium, and large. We ...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi LeRuyet 

 

Thanks to dk_dk and Jai-Rathinavel for their attention to this thread and their great replies.

Please consider accepting their replies as a solution if it has helped you solve your problem.

 

You may not have to use the RANK/CEILING function if you are only considering grouping. The following are ways to use conditional columns and DAX for your reference.

Create a conditional column:

Add a conditional column - Power Query | Microsoft Learn

1. Replace null values with 0

2. Create a conditional column to group based on the revenue column

 

Create a Calculated Column with DAX:

 

RevenueCategory = 
SWITCH(
    TRUE(),
    ISBLANK([Revenue]) || [Revenue] <= 5000, "Small",
    [Revenue] <= 10000, "Medium",
    "Large"
)

 

 

 

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi LeRuyet 

 

Just a friendly follow-up to this post.

May I ask if your problem has been resolved? If so please consider accepting helpful replies as a solution, it will make it easier for other users experiencing the same problem to find a solution.
If you have any other questions, please feel free to contact me.

 

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