SUM with two dates filters

[Anonymous]

Hello,

I would like to ask for help.

I have 3 columns: price, date1 and date2

How can I create measure where SUM of price with filter date1 is less that today and filter date2 is not blank.

Thanks.

[MahyarTF · Accepted solution]

Hi,

use the below code for creating the Masure :

SpecificPriceSum =

            CALCULATE(sum(Sheet34[Price]),

                       Sheet34[Date1] < TODAY(),

                       Sheet34[Date2] <> BLANK()

                     )

Appreciate your Kudos and please mark it as a solution if it helps you.

[Rutuja_Kalbhor · Accepted solution]

Assuming your table is called "Table":

Measure = CALCULATE(SUM('Table'[Price]),'Table'[Date1]<Today(),NOT ISBLANK('Table'[Date2]))

CALCULATE() allows multiple filters.

[MahyarTF · Accepted solution]

Hi,

use the below code for creating the Masure :

SpecificPriceSum =

            CALCULATE(sum(Sheet34[Price]),

                       Sheet34[Date1] < TODAY(),

                       Sheet34[Date2] <> BLANK()

                     )

Appreciate your Kudos and please mark it as a solution if it helps you.