How to keep years the same regardless of cashflow start date

[Anonymous]

Currently I have built a table that has several line items that include yearly cashflows. I am looking to establish in the table the same time frame for the whole chart. Ex. I may have one line item with cash flows in Year 1 (2017),Year 2 (2018),Year 3 (2019),Year 4 (2020) which his exaclty what I want. The next line item has cash flows starting in Year 1 (2019), Year 2 (2020), Year 3 (2021), Year 4 (2020). I'll provide a better example before but I would like to know how to have the second line item report a 0 value for the first two years until 2019 comes into play.

Line 1    2017         2018         2019        2020

             $1,000      $2,000      $3,000      $4,000

Line 2    2017         2018         2019        2020

              $0             $0            $2,500     $3,500

I'm new to Power Bi so my question/description is most likely a poor one. But above is how I would like my numbers to appear. Regardless of when the cashflows start I would like to keep the same year permeters. currently on line 2 -- Year 1 would be $2,500 even though it starts in 2019. Any help would be greatly appreciated.

[Iadem · Accepted solution]

If you need result how at screenshot, then use measure

Measure =
IF ( Sum[value2] > 0; SUM ( [value2] ); 0 )

DB:

[v-ljerr-msft]

Hi @Anonymous,

Could you post your real table structures(including the measures you're using) with some sample data? So that we can better assist on this issue? 

Regards