Line Percentage MoM completion Comparison

[Kostas]

Hello Everyone, 

Once again need your help. 
I am having the below table

Reference	Status	Date Completion	Plan Year
Ref1	Complete	05/06/2020	2020
Ref2	Incomplete		2020
Ref3	Complete	08/06/2021	2021
Ref4	Complete	09/11/2021	2021
Ref5	Complete	08/04/2022	2022
Ref6	Complete	02/08/2022	2022

What I need is to produce that shows the percentage completion on month by month basis. Each line in the line graph to present the percentage completion of each year as to the total number of references for each plan year. Something Like:

Where each line will be in legend:

Blue = 2022 (In progress)

Red = 2021

Purple  = 2020

and in the X axis I will have the months (i.e. January February March etc.)

What I have done already was to create a calendar table and create the following measure one for each year (2020,2021,2022):

Completed Proportion 2020 = 
Var Measurement = 
IF(
    MAX('Calendar'[Date])  <= TODAY() || 
    MAX('Calendar'[Date].[Year]) = YEAR(TODAY()) && MAX('Calendar'[Date].[MonthNo]) = MONTH(TODAY()) ,
	 CALCULATE (
        DISTINCTCOUNT ('Table'[Reference] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date Completion] <= MAX ( 'Calendar'[Date]) 
        ) ,
         NOT(ISBLANK('Table'[Date Completion] )), 'Table'[Status] = "Complete",
         'Table'[Plan Year] = "2020"
    )
,
BLANK()
)

Var TotalAudits = 
CALCULATE(DISTINCTCOUNT('Table'[Reference]), 'Table'[Status] <> "Incomplete",'Table'[Plan Year] = "2020")

RETURN
Measurement/TotalAudits

But when I placing all three measures in my line graph I am not getting it in MoM basis but as total delivery throughout the three years. It works only when I drill down to split the hierarchy while when I am choosing to just drill down to next level it does not return any results.

Can you please assist?

[amitchandak]

@Kostas , You can have measure for current and last month and then use

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))

diff %= divide([this month]-[last month], [last month])

and use this measure with month on axis and year as legend and you have use those from date table 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[Kostas]

Hello @amitchandak and thanks for your reply. 

How the date within the calculation is connected with the completion date in the table above?
Sorry I am not sure how that works. 
Also, in the last calculation you are using the Previous and This month calculations, how should I utilise the first two measures?