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 ...
Jai-Rathinavel's avatar
Jai-Rathinavel
Icon for Super User rankSuper User
1 year ago

Hi LeRuyet ,

 

You can create a RevenueRank column using the below M statement, I have included nulls and zeros in my dummy data and generated this expression. You can refer the "#Added Rank"  step and include it in your m code. Once rank column is created at Power query level, you can create calculated column at DAX level

let
    Source = Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Revenue = 200],
        [CustomerID = 2, Name = "Jim", Revenue = 0],
        [CustomerID = 3, Name = "Paul", Revenue = 200],
        [CustomerID = 4, Name = "Ram", Revenue = null],
        [CustomerID = 4, Name = "Ringo", Revenue = 500],
        [CustomerID = 4, Name = "Julie", Revenue = null],
        [CustomerID = 4, Name = "Stella", Revenue = 0]
    }),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text},{"CustomerID", type text}, {"Revenue", Int64.Type}}),
    #"Added Rank" = Table.AddRankColumn(#"Changed Type", "RevenueRank", {"Revenue", Order.Descending}, [RankKind = RankKind.Dense])
in
    #"Added Rank"

 

Did I answer your question ? Please mark my post as a solution

 

Thanks,

Jai ðŸ™‚