Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

date format doesn't work in if function

Hi,

I've tried the following if statement in a calculated measure:

TestDate = if(1=1,now(),0)

But instead of a date I am getting this output when I put the measure into a Card:

42K

I've tried changing the format to "Date" but that option is ghosted out. Please do you know how to fix?

Thanks,

CM

MarcelBeug
9 years ago
Because the value-if-false is not a date. If you replace that with a date value, then you'll be fine.

Example: TestDate = if(1=1,now(),DATE(2017,1,1))

3 Replies

Anonymous
Not applicable
9 years ago
the full output with 15 decimal places is:
42.833606497689999 K

so I think this is a datetimestmp (with 42833 being the 8th April 2017). And the remaining decimal places being the time. But why does Power BI refuse to display this as a date/time?
- MarcelBeug
  Community Champion
  9 years ago
  Because the value-if-false is not a date. If you replace that with a date value, then you'll be fine.
  
  Example: TestDate = if(1=1,now(),DATE(2017,1,1))
  - Anonymous
    Not applicable
    9 years ago
    Thank you Marcel :-)

Related content