Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a problem and I cannot figure it out on my own.
I need to transform the amount of days into [TEXT] '< 3 months' (<90 days) or [TEXT] '> 3 months' (>89 days). The transform options do not give a solution, or i cannot find it. Please help me out. I think there must be a simple solution :).
Thanks in advance!
Solved! Go to Solution.
Hi @Flappy8Flapjack , you can create a calculate column:
Result = SWITCH(TRUE(),
'Your column Amount of days'<90, "<3 months",
'Your column Amount of days'>89, ">3 months",
""
)
I hope works for you, Best regards
@Flappy8Flapjack, It would be better if you share sample data along with expected output in excel format.
Hi @Flappy8Flapjack , you can create a calculate column:
Result = SWITCH(TRUE(),
'Your column Amount of days'<90, "<3 months",
'Your column Amount of days'>89, ">3 months",
""
)
I hope works for you, Best regards
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |