Forum Discussion
Getting data based on the last date in a matrix
Hi, I'm new in powerbi and I struggling to create a matrix based on updates in a table. What I want to get is the following: The columns are the dates. In the lines I have tickets (from ...
I assumed you had an separate calendar table. You can just append the fill down the blanks. For example, 2021.1.2 is missing in the below table. You can merge it with the calendar date and fill down value. Check applied steps in the pbix.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Hi Paul,
many thanks for your reply.
I was considering doing that.
Only ... it's not just one ticket, but thousands. I would need a table with all the dates and with all the tickets. Therefore I thought it would be a better solution to create some kind of measure that gets the data on the fly in a report.
Regards
Timo