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.
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.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |