Forum Discussion

Aliba24's avatar
Aliba24
Frequent Visitor
6 years ago

Default values in Matrix

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

Need Help

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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's avatar
      Aliba24
      Frequent Visitor
      6 years ago

      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