Forum Discussion

carolynhn25's avatar
carolynhn25
Advocate 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 trying to do.

 

1. I need to filter the data in the table to only return results inbetween the dates in two columns

 

2. I want the report page to default to today's date, with the option of changing the date with a slicer

 

So the end result I'm aiming for is for the data to be filtered to only include rows with a date inbetween the two columns, and then the report page auto-filtered for TODAY with the option of adjusting the dates via slicer. 

 

Thank you in advance for any help you're able to provide!!

Need Help

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super 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] )
    )
)