Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Calendar filtering table

I have a calendar table, Date being the primary key. I would like to add a Calendar filtering table that can be used as a slicer so that end users can quickly select Calendar YTD, Fiscal YTD, Last 12 Months, Current Month, etc. and it will filter the data by the appropriate date range. Is there an easy way to do this with dax based on current day? I don't want individual measures for each date range.

Super User IV
Super User IV

@smileamile4 , Please refer to my video around this topic

All About Time Intelligence around Today:

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

That's time intelligence in general, with measures. What I'm wanting to do is provide a drop-down selection for users to select from a set of pre-determined Date Filters. This table would filter my calendar table that would then filter my fact table. User would be selecting an option that's in the TimeFilter field below, and the Date field would be tied to the calendar table (*:1 relationship). Essentially it would look like the below (unless there is a better way to do this without setting individual measures for each time filter type. The point of this is to have one report page that can quickly change the date ranges.



* in the sample above, I only did the first few days and last day of the full date ranges I'd expect, for demonstration purposes.

Hi @smileamile4 ,


I read your video link, it really helped your question. May I ask if your needs have been solved now? If the problem has been solved, you can mark your answer as the correct answer to help the other members find it more quickly. If it is still not solved, please provide detailed demand information and data model, I will answer you as soon as possible.

Let me know the result immediately, looking forward to your reply.

Best Regards,

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

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors