Forum Discussion
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 ...
dk_dk
Super User
Super UserHi LeRuyet
I am not really following why you would need CEILING and Rank columns, if your goal is to create a category column based on the revenue column.
You should be able to create your category column in Power Query with a conditional column, or with DAX calculated column, where you can specify the criteria for categorisation. If you need any help with doing that, or if there is some specific tutorial you are trying to follow that uses CEILING and ranking, please share a sample of your data (or the pbix file if you can) and instructions you were trying to follow.
Best regards,
Daniel