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!

  • JoHo_BI's avatar
    JoHo_BI
    Responsive Resident
    9 years ago

    Hi myti,

     

    What didn't work about it? What responses/errors did it give? 

    • myti's avatar
      myti
      Helper II
      9 years ago

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

       

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        Can you please add 3 test columns to your table (to be deleted later)

         

        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