Forum Discussion
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
1 Reply
- stevedepMemorable Member
No response yet, I suggest to follow:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490