Forum Discussion

myti's avatar
myti
Helper II
9 years ago

Date format problem

Dear Experts,   I have a calculated Measure which is  an output in Date format like 1/1/2017. Once I want to use this output in if condition I can not get the correct answer and "if condition" can ...
Need Help
JoHo_BI's avatar
JoHo_BI
Responsive Resident
9 years ago

Hi Myti,

 

Try converting your measure to a date too, such as:

 

CalculatedColumn=IF(DATE(YEAR([Measure]), MONTH([Measure]), DAY([Measure]))=DATE(2017,1,1),1,0

 

Hope that helps!

myti's avatar
myti
Helper II
9 years ago

Hey JoHo_BI,

 

Thank you for your response.However,It did not work!