Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
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.
Giuseppe
Solved! Go to Solution.
Try this column
= VAR lastavailabledata = CALCULATE ( MAX ( Tabella2[dataworked] ), FILTER ( ALL ( Tabella2 ), Tabella2[dataworked] <= Tabella1[data] ) ) RETURN CALCULATE ( SUM ( Tabella2[outputactual] ), FILTER ( ALL ( Tabella2 ), Tabella2[dataworked] = lastavailabledata ) )
Hello Muhammad,
your formula work perfectly.
thanks a lot
Giuseppe
HI @GiuseppeTE
Thanks for the feedback
Please mark the correct answer as solution. I see that you marked your own reply as ANSWER.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |