Forum Discussion
DAX Power BI- Need a help on Formula
Dear All, I would apprecaite, if you could help me to find an error in the formula below. Month_Groups = SWITCH(TRUE(), AND(MYK_AD_20230428[Date_Month]<12),"Less than 12 Month", AND(MYK_A...
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:
AND(MYK_AD_20230428[Date_Month]<12),"Less than 12 Month",
Thank you in advance.
Best regards,
Jelena
Sahir_Maharaj
Super User
Super UserHi 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
- Sahir_Maharaj
Happy to help! Should you require any further assistance, do not hesitate to reach out to me 🙂