Group with DAX

[feralvarez994]

Hi everyone! I have an issue here,

i have a column in which i have transformed a number string in date (AT_FECREM_NEW)

and then another column that makes the datediff between that day and today.

The thing is that i want to group those results in 4 groups:

 - 0-30 days

 - 30-60 days

- 60-90 days

 - more than 90 days

I'm doing this in this way but im finding an error

When i make the calculated column with if, it tells me that cant use Variant data type to define calculated columns, can someone help me? I tried using PQuery but in there there are not shown the columns that i create with DAX.

[v-zhangti · Accepted solution]

Hi, @feralvarez994 

Maybe you can try to carry out one more step.

Column:

Group = 
IF([Dias]>90,1,IF([Dias]>60,2,IF([Dias]>30,3,IF([Dias]>0,4,0))))

Column = 
IF([Group]=1,">90",IF([Group]=2,"60-90",IF([Group]=3,"30-60",IF([Group]=4,"0-30","0"))))

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

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

[feralvarez994]

Hi! This works, thanks you a lot!

[AilleryO]

Hi,

Can you check the Data type of your calculated column [Dias C antiguidad] ?

It might not be a type numeric (whole number, or Decimal value or fixed decimal value).

To change type, select your column  in field panel, then go to Column Tools tab et choose a numric data type and choose your format as well.

Tell us if it works after changing the type ?