Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Amardeep100115
Post Prodigy
Post Prodigy

how to Create calendar

‎09-14-2018 12:16 AM
How to create calendar in BI which show us Lease Start and End Date
AB
Labels:
Message 1 of 5
1,521 Views
0
2 ACCEPTED SOLUTIONS
v-yuezhe-msft
Employee
Employee

‎09-16-2018 10:54 PM

@Amardeep100115,

Please create the calendar table using DAX below and check if you get expected result.

Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date]))

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 2 of 5
1,518 Views
0
v-yuezhe-msft
Employee
Employee
In response to Amardeep100115

‎09-20-2018 02:22 AM

@Amardeep100115,

Glad to hear the issue is solved, you can accept my reply as answer to close this thread.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 4 of 5
1,504 Views
0
4 REPLIES 4
v-yuezhe-msft
Employee
Employee

‎09-16-2018 10:54 PM

@Amardeep100115,

Please create the calendar table using DAX below and check if you get expected result.

Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date]))

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 5
1,519 Views
0
Amardeep100115
Post Prodigy
Post Prodigy
In response to v-yuezhe-msft

‎09-20-2018 01:56 AM

Thanks, got resolved

 

AB
Message 3 of 5
1,503 Views
0
Amardeep100115
Post Prodigy
Post Prodigy
In response to Amardeep100115

‎09-28-2018 12:49 PM

I got my answer

AB
Message 5 of 5
1,481 Views
0
v-yuezhe-msft
Employee
Employee
In response to Amardeep100115

‎09-20-2018 02:22 AM

@Amardeep100115,

Glad to hear the issue is solved, you can accept my reply as answer to close this thread.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 4 of 5
1,505 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All