Creating Issues with Outlook Date

Hi, I’m trying to create a measure that is very similar to “Issues with Due Date”. I would like to make an “Issues with Outlook date” so I can plot my outlook over time.

I was trying to use issues open to get me in the right direction to make “Issues Outlook” and here’s where I got.

` CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN

Cache([Measures].[Issues created]
- [Measures].[Issues resolved])
+ [Measures].[Issues created]
- [Measures].[Issues resolved]
– optimized formula for drill through Issue
[Issue].CurrentMember.get(‘Outlook Date’),
[Measures].[Issues created]),


Actually, there is a simpler approach to calculate this.

eazyBI recognizes date-picker custom fields by default. Please check if you can already now import your custom field “Outlook Date” as measures via eazyBI import settings.

This would create in your eazyBI account a new measure “Issues with Outlook Date” which you could use.

Please check and update your eazyBI import settings and import the data to create your expected measure.

Best regards,
Martins / eazyBI team