Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
owenian5
Helper I
Helper I

How to filter 4 different tables by Year, Month, Week and Date?

I have 4 different tables in power query and each table has its own 'Year', 'Month', 'Week' & 'Date' columns.  What can I do such that I can filter all 4 tables using the filters below?

owenian5_0-1681718548633.png

 

2 REPLIES 2
amitchandak
Super User
Super User

@owenian5 , Create a common date table with year, month week etc and join that with all for tables to filter

 

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

 

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

 

Date Table in Power Query

https://medium.com/@amitchandak/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1

Thanks for your help. But right now the table consist of dates for the whole year 2023. However, is there anyway I can limit the 4 filters to display YEAR, MONTH, WEEK & DATE only till TODAY()? 

 

The issue is YEAR, MONTH, WEEK & DATE fields are all related to each other.  E.g. When I select "April" for MONTH, it should only show '13,14,15,16' for WEEK, etc.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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