Repeat values IF

[idontexist]

Hi all,

I want to repeat values as you can see in column "should be plan". It should be based on column "Fact". If in this column there are any values so plan should be repeated. "Plan" i have 1 value for whole month, so you can try to use logic with "first-day-of-month" = 1.

This i use, but it did not work: Matrix Plan = if([Fact]<>"";CALCULATE(sum('table1'[Plan]);'Date'[Day Of Month]="1";""))

DSR Code	Date	Fact	Plan	Should be plan
RRUM116	01.08.2017	173	194	194
RRUM116	07.08.2017	177		194
RRUM116	08.08.2017
RRUM116	14.08.2017	3		194
RRUM116	15.08.2017
RRUM116	21.08.2017	3		194
RRUM116	28.08.2017	3		194

[technolog · Accepted solution]

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Repeating-values/m-p/308762/thread-i...