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

Calendar Dates are not Filtering as per dates

I am using  calender command which makes a calendar as per min date and max date, but this calander is filtering as per role Mention in  power bi ,


I have a data which related to multiple property and in which  , property "A" started in 2011 and second property "B" started in 2013 to til now , I have set a role according to property A and B,


I want when i select Property A Calender year and dates should be starts from 2011 and When select B calender year should be start from 2013. Please find the below code which i am to make calender table .


Date =
DATE ( YEAR ( MIN ( Table1[Check Date] ) ), 1, 1 ),
DATE ( YEAR ( MAX ( Table1[Check Date] ) ), 12, 31 )
"Year",INT(FORMAT ( [Date], "YYYY" )),
"Month Number", INT ( FORMAT ( [Date], "MM" ) ),
"Month Name", FORMAT ( [Date], "MMM" ),
"Month Full Name", FORMAT ( [Date], "MMMM" ),
"Quarter", "Q" & INT ( FORMAT ( [Date], "Q" ) ),
"Week Day Number", INT ( WEEKDAY ( [Date],2 ) ),
"Week Day", FORMAT ( [Date], "DDDD" ),
"Year Month ",FORMAT ( [Date], "MMM" ) & " " & YEAR ( [Date] )



Below screen shot showing data which is coming after setting the role and but year is not filetring as per Table1 date for Property it still starts form 2011 wheree as property B dtata starts from 2013.













You cannot change a table calculation based on a role. Instead, build the max calendar table you need.  You could probably filter it using a suitable measure against a slicer on the calendar table

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!