Two different date

[smilingjohn]

Hi All, 

I have two dated one is "Order Date" and the second is "Update Date".

Now How can I get the common month from this two date and show the tickets raised 

Thanks in Advance

[Taoufiq_Zarra]

@smilingjohn  can you share a sample data and the expected output ?

[sonkumamon · Accepted solution]

You can use a date bridge table:

DateBridge:

Load

TicketID

OrderDate as Date

'Order' as DateType

Load

TicketID

UpdateDate as Date

'Update' as DateType

And then in the chart you can use the Date field as the dimension, and as a measure use:

Count(Distinct TicketID)