Only show value for first date in table

Question

Dear all,&nbsp;My source looks like this:Delivery PeriodEconomical PeriodValueJanuary 2020January 2020100January 2020February 202050February 2020February 202020February 2020March 202030&nbsp;What I need is my output table to ONLY show the INITIAL value of the economical period and to leave the other rows empty.&nbsp;Desired output table:Delivery PeriodEconomical PeriodInitial ValueJanuary 2020January 2020100January 2020February 20200February 2020February 202020February 2020March 20200&nbsp;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?&nbsp;Thank you!

amitchandak · Accepted Answer

AVIE ,
Try a&nbsp; measure like
&nbsp;
calculate(Sum(Table[Value]), filter(Table, Table[Delivery Period]=Table[Economical Period]))

Forum Discussion

Only show value for first date in table

1 Reply

Related content

Formatting Value of Table

PowerBI - Matrix table, hide values used only for a visual calculation

Table Call Value Formatting Options

Return "Specific value" from table 1, if not found, return value from table 2

Parsing list values in a nested table

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

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