Forum Discussion

AVIE's avatar
AVIE
Frequent Visitor
5 years ago
Solved

Only show value for first date in table

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 Feb...
  • amitchandak's avatar
    5 years ago

    AVIE ,

    Try a  measure like

     

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