Measure to sum values based on whether a date in a separate column falls between two dates

[shaunmag]

I have a table fed into my PowerBI, that looks like the table below.

I want to create a measure with a formula that does the following:

Sum all of the footprint if the property strategy is "Exit", and if the "When" value is between 01 Jan 2022 and 31 Dec 2022.

Is that possible?

Property Name	Property Strategy	When	Footprint
[Text]	[Text]	[Date]	[Number]

[Anonymous · Accepted solution]

Hi @shaunmag , 

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
CALCULATE (
    SUM ( 'Table'[footprint] ),
    FILTER (
        ALL ( 'Table' ),
        YEAR ( 'Table'[date] ) = 2022
            && 'Table'[property strategy] = "Exit"
    )
)

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

@shaunmag 

MEASURE =
CALCULATE(
	SUM('Table'[Footprint]),
	'Table'[Property Strategy] = "Exist",
	YEAR('Table'[When] ) = 2022
)

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂