cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Adiuser Frequent Visitor
Frequent Visitor

Creating a calendar date as slicer to filter two dates from two different fact tables

I have two fact tables one on demand and the other on supply. I have a date range column say start date A and end date A in Demand Fact and just Date B in Supply fact table. Now I have a report which displays both demand and supply information and I want to enable a date slicer but I cannot use either of the date columns from facts as they will filter respective tables relevant information only. I do not have a calendar table or any other time dimension table to pull a common date slicer to act on both demand and supply. How do I achieve this? Can I have a calendar date which has all the day's dates which I can use to act as a common slicer for both demand and supply display in grid report? (or)Can I create a calendar table in power BI with columns like month , year and day ( not sure of the functions to create them though ) and use this table to join calendar.day = demand.start date A and calendar.day=demand. end date A and join calendar.day = Supply.date B , Is this a right approach? if so what function can I use to create month , year and day columns? Appreciate any inputs on the same. Thanks In Advance.
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Creating a calendar date as slicer to filter two dates from two different fact tables

@Adiuser,

 

You may use CALENDAR Function or CALENDARAUTO Function to add a calculated table.

Community Support Team _ Sam Zha
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

1 REPLY 1
Community Support Team
Community Support Team

Re: Creating a calendar date as slicer to filter two dates from two different fact tables

@Adiuser,

 

You may use CALENDAR Function or CALENDARAUTO Function to add a calculated table.

Community Support Team _ Sam Zha
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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)