How to plot Monthly % Ontime

[Kampua]

Hi,

I have a table showing the agreed date, actual date, and whether it was dispatched on time (see below). I need to plot a line showing the % dispatched ontime for each month, how do I do that in PowerBI. 

[Kampua]

It works thanks 🙂

[amitchandak · Accepted solution]

@Kampua ,  Try a measure like

divide(Countrows(filter(Table, Table[Ontime] = "Yes")),Countrows(Table))

refer, how two dates can use same date table - https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...