Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |