Forum Discussion

carolynhn25's avatar
carolynhn25
Icon for Advocate III rankAdvocate III
3 years ago

Date Filters/Functions in DAX

Hello!   I am trying to use two date columns from the same table to filter a page in my report but am having difficulty getting the end results that I want. There are two components to what I'm try...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

 

 

 

Value measure: =
CALCULATE (
    SUM ( Data[Value] ),
    FILTER (
        Data,
        Data[DateStart] <= MAX ( 'Calendar'[Date] )
            && Data[DateEnd] >= MIN ( 'Calendar'[Date] )
    )
)