Forum Discussion
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 ...
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
I added 3 columns as you mentioned. Unfortunetly, the results for all variables is nan.!