this is my first time in the comunity and I am a new user of power bi.
The issue I would like to solve is the follow:
I have to table like below:
where the table 1 have a calculated column with the following formula:
now the issue is:
how I can fill the rest of blank value in the column calculated with the last one value (15) ?
below the related table2:
thanks in advance for every one would like help me.
Go to Solution.
your formula work perfectly.
thanks a lot
Try this column
VAR lastavailabledata =
MAX ( Tabella2[dataworked] ),
FILTER ( ALL ( Tabella2 ), Tabella2[dataworked] <= Tabella1[data] )
SUM ( Tabella2[outputactual] ),
FILTER ( ALL ( Tabella2 ), Tabella2[dataworked] = lastavailabledata )
Thanks for the feedback
Please mark the correct answer as solution. I see that you marked your own reply as ANSWER.
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.