Forum Discussion
Returning text based on difference
create a column:
date diference = DATEDIFF(date1;date2;DAY) (use semicolon or comma)create another column:text result = If (date diference <= 50;"New";date diference <= 150;"Existing";"Old")best regards.
Based on your example and assuming [Date Difference] is a measure this should work.
Text =
SWITCH(
TRUE(),
[Date Difference] = 151, "Existing",
[Date Difference] = 50, "New",
[Date Difference] = 152, "Old",
"Other"
)
jdbuchanan71 Thanks for this, but it then throws out the error of MdxScript(Model) (140,98), 'SWITCH' does not support comparing values of type True/False with values of type text. I dont have any columns or values that are of Ture/False types, so not sure why it wont accept the measure?
TIA
UK_User123456 , You will need to share your model, the measure works in my test:
jdbuchanan71see below the screenshots. The data types should are the same, as there are no true/false.
I wanted to be able to say that if the "Date Difference is between a certain number it would return the text I wanted it to display. I have also attached the error message that I receive.
Can you share the nested IF statement that you tried? I dont see any reason as to why a nested if statement wouldnt work here!
