Forum Discussion
HV27
2 years agoNew Member
To set criteria using Calculated columns.
CustIncome = SWITCH(TRUE(), DimCustomer[YearlyIncome] < 25,000, "LOW INCOME", DimCustomer[YearlyIncome] >= 25,000 && DimCustomer[YearlyIncome] ...
edchuy
2 years agoAdvocate V
Taking a quick look at your code, it looks to me that you should remove commas that you have added to the numbers since those are probably the reason why they are being considered as text rather than as a number. Let me know if this fixes your code.