Problems with DateDiffDays

Hey guys and gals!

I am quite new to eazyBI and trying to use the DateDiffDays function for a calculated measure.
This one is even a function from the documentation:

DateDiffDays([Measures].[Issue status updated date], Now())

Sadly my results look like this:


So it is only showing the format type? Why?
What am I doing wrong? :thinking:

I simply used the “issue” dimension.

Thanks already for any kind of help! :hugs:

Hi @vicky,

The expression for calculation is correct. There are dates used in the formula, and eazyBI, unfortunately, thinks that the default result format will also be a date and return date format “mmm dd yyyy”.

To make this work, change the formatting to decimal.

For more details, please see the documentation Calculated measures - formatting.

Zane /

1 Like