Forum Discussion

Cakos's avatar
Cakos
Frequent Visitor
6 years ago

Cumulative value, repeat last value

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