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.
