Problems with DateDiffDays

Questions & Answers
,
1

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:

image

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:

2

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.

eazyBI change measure formatting
eazyBI change measure formatting1262×716 71.8 KB

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

Best,
Zane / support@eazyBI.com

1 Like