how to fill left months with previous month same value

[pauliuseg]

hi all, 

i have quite simple problem , but stucked in it ..

i have table, and latest actuals are March figures.

for mont ago calculation i use simple formula

Profits forecast montago = CALCULATE([Total Profits],DATEADD(Calendar[Date],-1,MONTH)).

and in 2021-April i get March data.

the question is how to fill left moths with same data ? 

it's like forecast based on last months actual figures.

maybe something like , first define some variable, and then say .

if (ISBLANK( [Total Profits] ), ..... then return variable  ).

not good in dax, but learning in progres..

thank you ! 

Paul.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[pauliuseg · Accepted solution]

hi all,

 i did it via  this, sharing, maybe somebody will be usefull

if (isblank([Total Profit]);CALCULATE( sum(Profits[Total Profits]);DATESBETWEEN( 'Calendar'[Date]; "2021-03-01" ; MAX('Calendar'[Date]) ));"")

so instead of 2021-03-01, you can ad something you need some max date or similar