I try to find a solution for the following:
(The value is a count.)
As long as there is no data for "nr 2" for "3" I need the previous count ("nr2" & "2").
So basically the matrix should be filled in to be like this;
Go to Solution.
I've rebuild the matrix in a new table in query editor and used the Fill down function.
You may take a look at the following posts.
Hi, Thanks for your time.
I've tried both solutions. Both measures are correct, but they give the same result as i had before, blanks are still blank.
I guess i might have to add a calculated column with a count for the biggest existing value and give this count if there is a blank... What do you think?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.