Get the landing of exercice

[Vince_76]

Hello Community,

I would like to do one thing in Power BI.

Each month I get the investments and the year-end projection updated.

I have the 2 tables  below (one for data and one for target)

	Invest	Landing
January	100	1200
February	200	1200
March	300	1300

  Targets are entered in advance for the entire year and so I have all the values for the months

	Target
January	100
February	200
March	300
…
September	1200

I would only to show the landing point at end of exercice for the last month of exercice (september). What I want represented is this :

	Invest Display	Landing Entry	Target Display	Landing Display
January	100	1200	100
February	200	1200	200
March	300	1300	300
…
September			1200	1300

I'm a rookie and I can't get the graph I want.

Your help will be welcome!

Thanks in advance.

[kentyler]

Do you have a relationship defined between the 2 tables (probably on the month column) ?

[Vince_76]

Hello, yes i have a relanshionship by date in the calendar tab.

I have succeeded to create a line for landing by the formula

=calculate(claculate(sum(Data[Value]); filter(Data; and (Data[Date]=MAX(Data[Date]);Data[KPI]="Invest")));allselected())

Thanks for your help