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
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

myti

 

Make sure your [Measure] returns date type. As I tested, it supposes to work with your original formula.

 

 

Regards,

parry2k's avatar
parry2k
Super User
9 years ago

Try this:

 

Measure = If ( HasOneValue('landing-pages'[ipg:month]) , Values ('landing-pages'[ipg:month]), BLANK())

CalculatedColumn=IF([Measure]=BLANK() ||[Measure]<>DATE(2017,1,1),0,1 )

Assuming ipg:month is data type, as v-sihou-msft suggested, make sure your measure data type is also Date