Calculate the difference between two measures

Questions & Answers
1

Hi EazyBI community, I would like to calculate the difference between to dates (Issues created at and Issues Date of first response).

My calculation looks like this:

DateDiffWorkdays(
      [Issue].CurrentHierarchyMember.get('Issues created at'),
      [Issue].CurrentHierarchyMember.get('Issues [CHART] Date or first Response'), 
      '67')

Unfortunately within my table I do not receive any value back.
I have checked the format which is set to yyyy-mm-dd hh:mi:ss Date and time as the other measures use this format.

Could someone please support me here.

2

Hi @merit_muehlenfeld,

DeteDiffWorkdays() is the right function to calculate the duration between two dates. The outcome is the duration expressed as a number of days, not a date. You might want to set measure formatting to ###.## decimal.

The calcaution is based on issue properties and compares dates for individual issues; therefore, it would work only when individual issues are on report rows. This sample report might help you to understand the concept better why some calculation work only for specific layout: Project issues with details.

Best,
Zane / support@eazyBI.com