Default values in Matrix

[Aliba24]

Hi everyone,

I'm working on the so-called "Surplus" report and faced some small annoying issue.

As you may see from the picture above, there are some months with no payments, therefore no records in the table. So, what I want is to fill these gaps with previous values. Is it possible inside Power BI or should I look into the SQL query?

Thanks in advance!

Alibek

[v-lionel-msft]

Hi @Aliba24 ,

Are your previous values and current values from the same table? If not, what's the relationship betwwen two tables?

Could you give me a sample data model? Maybe there's a way to solve the problem if I can see the data model.

Best Regards,
Lionel Chen

[Aliba24]

hi @v-lionel-msft 

I have only one table. And the data model is quite simple. Here's a small example of a report. You can find all the measures inside.

Alibek