Missing Data for some entries on certain dates

[Anonymous]

Hi everybody, I'm pretty new to Power Bi and I'm struggling with the following problem.

In our group, we receive by each country the balance of bank accounts (multiple account for one country) on a daily base.

This in theory, but in practice we have empty dates (different working days, skipped days...). So I have, for example, date for

• Argentina on the 1,2,4,6 Jan
• Brazil on 1,2,5 Jan and so on.

If I create a line report, for example for the total balances I get a jumpy line (while if I do it by country, the system interpolates).

I need to avoid these jumps, so the system has to fill in empty bank accounts values based on the last one available.

I tried to follow the instructions available here, but I got an error on the definition of the [Date] column.

Here you can dowload the PBIX.

Any suggestion would be super appreciated!

Thanks

Marco

[TeigeGao]

Hi @Anonymous 

According to your description, my understanding is that you want to get data of continous date rather than the date like below:

In this scenario, we can create another continous date table and create relationship between them, then add the data in the date table to this visual.

Best Regards,

Teige

[Anonymous]

Hi @TeigeGao 

thanks for the suggestion.

I try to explain further the need.

I want to add the rows in red in the table below (identical to the last day with available data, except for the date) so that when I draw the line chart of the total amounts (last 2 columns) with no detail by account/country ("€ bank balance worldwide" and "€ facility balance worldwide") it looks consistent (no holes).

Country	Bank Account	Date	€ Bank balance of the day	€ Facility balance of the day
Argentina	a	01/01/2019	4	5
Argentina	b	01/01/2019	3	1
Argentina	c	01/01/2019	8	2
Argentina	a	02/01/2019	5	5
Argentina	b	02/01/2019	2	1
Argentina	c	02/01/2019	7	2
Argentina	a	03/01/2019	5	5
Argentina	b	03/01/2019	2	1
Argentina	c	03/01/2019	7	2
Argentina	a	04/01/2019	6	5
Argentina	b	04/01/2019	8	1
Argentina	c	04/01/2019	1	2
Argentina	a	05/01/2019	9	5
Argentina	b	05/01/2019	10	1
Argentina	c	05/01/2019	12	2

I tried to do something similar to what you suggest: in the file you will find the table "Dates".

But it didn't work for me: in fact if I use that date and the € balance I get the result on the left, in the image, while I want the line to go through the point I draw (I choose a different date in the graph to make it graphically more clear):

If your solution works, I probably missed how it should be implemented: could you please explain further?

Thanks