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

Derive fiscal dimensions from multiple dates in different tables

We have a standard date table to derive fiscal dimensions which is joined to one of the dates( ship date) in the one of the tables.That gives us various fiscal  columns like period,year ,etc based on ship date.

 

Now we would like to be able to view /filter the data by fiscal year for a different date(Invoice date) in different table . Is it possible to derive fiscal dimensions from multiple dates from different tables without having to create multiple Date dimensions?

 

Thanks.

1 ACCEPTED SOLUTION
MariaP
Solution Supplier
Solution Supplier

Hi @AG_0001 ,

 

This video from Sam McKay of Enterpise DNA may help you:

 

https://www.youtube.com/watch?v=u8_aeLmXbVk

 

Maria

View solution in original post

1 REPLY 1
MariaP
Solution Supplier
Solution Supplier

Hi @AG_0001 ,

 

This video from Sam McKay of Enterpise DNA may help you:

 

https://www.youtube.com/watch?v=u8_aeLmXbVk

 

Maria

View solution in original post

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!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.