cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rahul_Bhatt
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 =
ADDCOLUMNS (
CALENDAR (
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.

 

 

 

 

 

123.jpg

111.png 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors