Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I would apprecaite, if you could help me to find an error in the formula below.
Solved! Go to Solution.
Hi Jelena,
Thank you for your prompt response. Could you possibly please try the following:
Month_Groups =
SWITCH(
TRUE(),
MYK_AD_20230428[Date_Month] < 12, "Less than 12 Month",
AND(MYK_AD_20230428[Date_Month] > 12, MYK_AD_20230428[Date_Month] < 24), "12-24",
AND(MYK_AD_20230428[Date_Month] > 24, MYK_AD_20230428[Date_Month] < 36), "24-36",
MYK_AD_20230428[Date_Month] > 36, "36+",
BLANK()
)
Let me know if you might need further assistance.
Dear Sahir, thank you very much for your answer. Unfortunately, the error is the same. It shows, that there is an error in this line:
Hi Jelena,
Thank you for your prompt response. Could you possibly please try the following:
Month_Groups =
SWITCH(
TRUE(),
MYK_AD_20230428[Date_Month] < 12, "Less than 12 Month",
AND(MYK_AD_20230428[Date_Month] > 12, MYK_AD_20230428[Date_Month] < 24), "12-24",
AND(MYK_AD_20230428[Date_Month] > 24, MYK_AD_20230428[Date_Month] < 36), "24-36",
MYK_AD_20230428[Date_Month] > 36, "36+",
BLANK()
)
Let me know if you might need further assistance.
Dear Sahir
It worked, thank you very much. You are hero.
Best regards,
Jelena
Happy to help! Should you require any further assistance, do not hesitate to reach out to me 🙂
Hello @Jelena_I,
To fix this issue, you need to modify the formula as follows:
Month_Groups = SWITCH(TRUE(),
AND(MYK_AD_20230428[Date_Month]<12),"Less than 12 Month",
AND(MYK_AD_20230428[Date_Month]>12, MYK_AD_20230428[Date_Month]<24),"12-24",
AND(MYK_AD_20230428[Date_Month]>24, MYK_AD_20230428[Date_Month]<36),"24-36",
MYK_AD_20230428[Date_Month]>36,"36+",
BLANK()
)
The error in the formula is related to the usage of the AND function. The AND function requires a minimum of two arguments, but in the formula you provided, some of the AND functions have only one argument.
Let me know if you might need further assistance.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |