Add missing line

[ValentinBIA]

Good morning Power BI Community !

I'm fairly new to Power BI, and I have an issue that I could not fix by myself, even after searching for other threads with similar problems.

I have my dataset with a customer ID, and for each customer ID, there are 4 months displayed (from 4 to 7). For each of those months, per customer, I want to know what is the number of rentals. The issue I'm having currently is that whenever a customer did not do any rental for one month, nothing is displayed. and I would like to have 4 lines per customer ID, one for each month, with the value 0 on the monthly_no_rentals columns if there was no rental this month.

Can you help me with that ?

Thank you very much

[prihana · Accepted solution]

My suggestion is to import the data in such way. 

E.g. Create a qry / Maintain another table with all the values (customer and four months with the zero value) and merge it with the table which has data.

[ValentinBIA]

Thank you for your answer !

I did what you told me to, but when I merge, I get 4 rows per customer, multiplied by the number of active months...

[prihana]

Show me a sample of the format you want your data

[ValentinBIA]

Actually, I finally managed to have what I was looking for, thanks to your instructions and a few more google searches.

But now I'm struggling to fill in the "null" lines, since I cannot use fill up nor fill down (both would give me wrong values), and I don't really know what to do next.

I'm currently trying using an index and some formula to only fill down if the value on the id column is the same as the value on the id column but one row above.

Maybe you can help too ?

Thank you very much