Fill in previous value if row value is not present in range (0:50)

[LSE95]

Hello,

I don't know how to solve the following question. Maybe someone can help me. I have a dataset where I have the number of customers which joined per month and year (e.g. January 2018) and left x months later. 

Example dataset

Year_Joined	Month_Joined	Left_after_months	Amount_of_customers	Still_Left
2018	01	0	2	720
2018	01	1	3	718
2018	01	3	4	714

So you can see the "Left_after_months" = 2 is missing, but not for each month _joined+ year_joined combination. If this is the case there should be filled in a row with 0 churned customers

Year_Joined	Month_Joined	Left_after_months	Amount_of_customers	Still_left
2018	01	2	0	718

This should be done for all values of Left_after_months between 0 and 50 for each Year_Joined and Month_Joined combination.

I would use the information in a line chart. Currently it looks like this:

So you can see one line chart per month in 2018, where each data point gives the number of customers which are still here after "Anzahl_Monate" (the amount of months). Unfortunately when no customer left in one specific month there is no row in the data.

You can see that at "Anzahl_Monate" = 0. Not every line has data there. How can I fill in rows per month and year if there is no row for example for "Anzahl_Monate" = 0?

I highly appreciate your answer and effort.

Best regards,

LSE95

[LSE95 · Accepted solution]

I solved it by changing the underlying data in the SQL Server.

[CTozzi]

@LSE95 would you create a measure to calculate the total of customers on the last date of the month and use it for your visualization?

Balance of Customers :=
CALCULATE (
SUM ( TableName[StillLeft] ),
LASTDATE ( TableName[DateColumn] )

)