Only show value for first date in table

[AVIE]

Dear all,

My source looks like this:

Delivery Period	Economical Period	Value
January 2020	January 2020	100
January 2020	February 2020	50
February 2020	February 2020	20
February 2020	March 2020	30

What I need is my output table to ONLY show the INITIAL value of the economical period and to leave the other rows empty.

Desired output table:

Delivery Period	Economical Period	Initial Value
January 2020	January 2020	100
January 2020	February 2020	0
February 2020	February 2020	20
February 2020	March 2020	0

So basically, I only need the table to show the value if delivery period = economical period.

The total of the measue should be 120 (100 + 20).
Which measure can I use to achieve this result?

Thank you!

[amitchandak · Accepted solution]

@AVIE ,

Try a  measure like

calculate(Sum(Table[Value]), filter(Table, Table[Delivery Period]=Table[Economical Period]))