Forum Discussion
feralvarez994
Helper II
Helper IIGroup with DAX
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 tod...
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.
v-zhangti
Community Support
Community SupportHi, 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.
feralvarez994Helper II
Helper IIHi! This works, thanks you a lot!