CODEWITHSUNDEEP
databasedataframepowerbi
matesio
matesio

Reputation: 1604

Filter multiple tables on single dateTime filter using powerbi

I'm trying to filter with single common date filter multiple tables using powerbi. I'm using postgres RDS engine with powerbi. What i need is

PS. Each table has own date column

My schema looks like.

Table1

t_id| Date

Table2

t_id| Date

Table3

t_id| Date

Table4

t_id| Date

Upvotes: 1

Views: 6778

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

You need to add a date dimension table, with relationships to the date fields in your tables. Then you can filter this common calendar table and the filter will be reapplied through these relationships.

You can create your own calendar table, or combine the dates from all 4 tables to get a list of all date values (merge queries), or use DAX function like CALENDAR or CALENDARAUTO to create such table. It is a good idea to mark it as date table.

Then add one to many relationships between this calendar table and date columns of your tables (calendar table on the one side).

Add a slicer with the date field from the calendar table, or report level filter on it, depending on your preferences, to filter on it.

Upvotes: 1

Related Questions