How to manage two dates in single dashboard

[Shahzad_Ahsan]

Dear Friends

I have an issue with the dates. I have two date fields 'Creation_Date' and 'Cancelled_Date'

I want to filter data by Year/Quarter/Months/Days using ONLY ONE FILTER.

I need two KPIs

1. Number of items created       Expression:  Count (Id)

2. Number of items cancelled    Expression:  Count(Id) where CancelStatus='Cancel'

How is this possible.

Sample data is attached

[sunny_talwar · Accepted solution]

Check here

Canonical Date

[Shahzad_Ahsan]

Hi Sunny

After lots of effort, I successfully implemented the concept of canonical date.

Thank You