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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Dvayro
Frequent Visitor

Filtering shared date table / multiple date dimensions

I'm building a new dataset and struggling with which date method to use.

I want to be able to use slicers to filter any of the three dates that will be used in the report, and I have a few date groupings that are specific to the separate date types (manufacture date, Availability date, Expiry Date).
This leads me to think separate date tables may be the simplest method.

However, it occurred to me that this would make it challenging (impossible?) to create a view of a measure over different date types (example below, because my words are not working well)

 Units manufacturedUnits Expired
Jan1'200500

Feb

2'0001'800
Mar1'300200

 

 

The only method i can think of to achieve both outcomes is to create the seperate date dimensions and then have a master date table connecting all three - snowflake style. Is there something i'm missing here? is there a simpler/better way?

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Dvayro 
Another option is to "generate" a table with dynamic measures.
I created a file with the example.

You can download it from This link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @Dvayro 
Another option is to "generate" a table with dynamic measures.
I created a file with the example.

You can download it from This link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.