cancel
Showing results for
Did you mean:
Helper V

## DATESBETWEEN function applied to a measure

Hi,

Is there a way to apply a datesbetween function to this measure?

`%  Sum = IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],SUMX(ALLSELECTED('Sort Table - Month Year'),[Measure 3]))`

I've tried this but it doesn't seem to be working:
`% Attendance Sum 2018 = IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],CALCULATE(SUMX(ALLSELECTED('Sort Table - Month Year'),[Measure 3]),DATESBETWEEN('DimDate'[Dates],DATE(2018,1,1),DATE(2018,12,31))))`

Thanks in advance for any help
2 REPLIES 2
Super User

@Niiru1 , Try like

% Attendance Sum 2018 =
IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],
CALCULATE(SUMX(ALLSELECTED('Sort Table - Month Year'),[Measure 3]),filter(all('DimDate'),(DATESBETWEEN('DimDate'[Dates],DATE(2018,1,1),DATE(2018,12,31)))
) )

% Attendance Sum 2018 =
IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],
CALCULATE(SUMX(ALLSELECTED('Sort Table - Month Year'),[Measure 3]),DATESBETWEEN('DimDate'[Dates],DATE(2018,1,1),DATE(2018,12,31)))
)

Super User

the filter context bring in by CALCULATE might be overwrited by ALLSELECT

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors