Cumulative value, repeat last value

[Cakos]

Hello everyone,

maybe you can help me with the following question.

In my table you can see 6 Measures:

Measure 1: Calculation-Measure

Measure 2 : year-on-year-comparison (Measure 1 2020 - Measure 1 2019) -> for example: 16,43-14,64=1,8

cumulative. Measure = TOTALYTD([Measure2]; 'Datum'[Datum].[Date])

Month number: date-diff-Measure, to calculate the remaining number of months by the end of the year

correction_fact = [**bleep**.  Measure] / [Month number]

In the "cumulative. Measure_help" I want to accumulate Measure 2 up to the current month (in this example it is March).

But no matter whether I set blank values or replace the following values with 0, Power BI calculates with the original values (what you can see in the result line). I want Power BI to repeat the last value for the follwing months (4,26).

Do you have any ideas how I can solve this?

Kind regards,

CaKos

[stevedep]

No response yet, I suggest to follow:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490