How to set future values of measure to last actual value

[Robert1981]

I have a model with different tables:

BPC (contains)                        Fin Item                         Period

Company Code                      Fin Item                         Month

Division                                  Aggregation Lvl1           Year

Period                                    Aggregation lvl2            Date

Fin Item                                  Aggregation lvl3           Period

In the period table I create a measure to calculate the net sales out of BPC, depending on the Aggregation lvl1 from Fin Item.

The matrix table in which I report this measure has the months go across.

THe measure only provides a value for the history. The future stays empty.

The formula I use is:

calculate(sum('BPC IS'[BPC_Amnt]),filter('Fin Item','Fin Item'[Agg Lvl 2]="1.1 - Net Sales"))

How can I get the future net sales values in the matrix, where the future values match the last actual period.

E.g.

April 2020 = March 2020 net sales value

May 2020 = March 2020 net sales value

etc.

[edhans]

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum