Get 2 line graph for 2 different date columns in power BI

[Anonymous]

Hi, I need help in creating two line graph for 2 different date columns in power BI. Snapshot : I have two columns in a file with the date of the tickets entered and another column for the date of those ticket completed. However I need to see the days on which these tickets were entered and closed. Any help would be appreciated

First column (Entered Date on)

Second Column (Date Completed on)

The idea is to get the statistics of each count per day in X axis.

I am looking to merge both the below stats. 

My data source

Date Entered On	Date Completed on
01-04-21	10-04-21
01-04-21	10-04-21
01-04-21	10-04-21
01-04-21	10-04-21
01-04-21	10-04-21
01-04-21	05-04-21
01-04-21	05-04-21
01-04-21	05-04-21
01-04-21	05-04-21
02-04-21	05-04-21
02-04-21	05-04-21
02-04-21	05-04-21
02-04-21	05-04-21
05-04-21	07-04-21
05-04-21	07-04-21
06-04-21	07-04-21
06-04-21	07-04-21
06-04-21	07-04-21
06-04-21	07-04-21
06-04-21	07-04-21
07-04-21	08-04-21
07-04-21	08-04-21
07-04-21	08-04-21
07-04-21	08-04-21
07-04-21	09-04-21
07-04-21	09-04-21
07-04-21	09-04-21
08-04-21	09-04-21
08-04-21	09-04-21
08-04-21	09-04-21

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

You can create a calendar table and two measures.

Like this:

Table 2 = CALENDAR(DATE(2021,4,1),DATE(2021,4,31))

complete =
CALCULATE (
    COUNT ( 'Table'[Date Completed on] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Date Completed on] = SELECTEDVALUE ( 'Table 2'[Date] )
    )
)

enter =
CALCULATE (
    COUNT ( 'Table'[Date Entered On] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Date Entered On] = SELECTEDVALUE ( 'Table 2'[Date] )
    )
)

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Brillant. Thanks @v-janeyg-msft it worked. You are a genius 🙂

[Anonymous]

Hi, Any help on this would be appreciated, Although it looks simple but I guess its difficult. @

amitchandak