Date format problem

Question

Dear Experts,&nbsp;I have a calculated Measure which is &nbsp;an output in Date format like&nbsp;1/1/2017. Once I want to use this output in if condition I can not get the correct answer and "if condition" can not recognise it.I dont know how I may have both in the same format to compre them in a if conditon. my current if condition is as below: I expect that the below formulah return 1 once Measure=1/1/2017.however it doesnt recognise them as equal and return 0. any idea how I can fix it?&nbsp;CalculatedColumn=IF([Measure]=DATE(2017,1,1),1,0 )&nbsp;Thank you,Best RegardsMehdi

myti · Answer

I dont receive any error,I dont recieve the answer that is expected. I supposed to receive 1 instead of 0 &nbsp;for column_test. Means that the formulah does not work.&nbsp;

joho_bi · Answer

Hi Myti,&nbsp;Try converting your measure to a date too, such as:&nbsp;CalculatedColumn=IF(DATE(YEAR([Measure]), MONTH([Measure]), DAY([Measure]))=DATE(2017,1,1),1,0&nbsp;Hope that helps!

myti · Answer

Hey&nbsp;JoHo_BI,&nbsp;Thank you for your response.However,It did not work!

joho_bi · Answer

Hi&nbsp;myti,&nbsp;What didn't work about it? What responses/errors did it give?&nbsp;

phil_seamark · Answer

Can you please add 3 test columns to your table (to be deleted later)&nbsp;My Year Col = YEAR([Measure])

My Month Col = MONTH([Measure])

My Day Col = DAY([Measure]) Just to see if these values are what you would expect

Forum Discussion

Date format problem

10 Replies

Related content

Date format issue

DAX Query Format Date

Date Format Problem

Problem with Cell Elements Formatting

Date Function Problem