SUM if date is less that today

[Jozef]

Hello,

I would like to ask for help.

I have a two columns: price and date.

How can I create masure to SUM the prices, where the date is less that today?

Thanks.

[amitchandak · Accepted solution]

@Jozef ,

calculate(Sum(Table[Price]), Filter(Table, Table[Date] < Today()) )

[Jozef]

Hello @amitchandak,

 And how can I handle measure if I have one price column and two different dates columns. I want to see sum of prices, where one date is less that today and other date have to be blank value (no date)

Thanks a lot