Calculate between dates

Questions & Answers
1

Hi
I wonder if there is a way to calculate dates between 2 issue in a report
image
For example if I have a Start date and wants to know for how many working days there are to Due date and also from Due date to Go live date

Hope you could assist me

Thanks

2

hello @Coachen
You are looking for DateDiffWorkdays()!

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datediffworkdays

Kind regards,
Vasile S.

1 Like
3

Hi VasileS

I have tried that one but I find it to work because If have different name on all projects
It would be great if I could take the data direct from column Start Date for example
Is there a way to do this?

Thanks

4

Sorry, what do you mean by “different name on all projects”?..
Values for Start Date is [Measures].[Start Date]…

image

image

Kind regards,
V.

1 Like
5

Hi
I have done as you describe

DateDiffDays (
[Measures].[Issue status Start Date],
[Measures].[Issue status Due Date]
)

But as you can see on image there are no dates in “Date Diff”
image

6

Hi @Coachen ,

You have the date properties “Issue due date” and “Issue Start Date” in the report. Why do you address different properties in the formula? Try the approach suggested by @VasileS with the properties you have in the report. See the suggested formula below:

DateDiffDays(
  [Measures].[Issue Start Date],
  [Measures].[Issue due date]
)

Best,
Roberts // support@eazybi.com

1 Like