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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
carlol
Helper IV
Helper IV

Data not all at the same granular level

Hi 

 

I have a data model, fact / dimensions  , everyfact table minus one can drill down as ganular as datatime 

the fact table D , I am having issues, ganularity is year / Quarter ; nightmare trying to link ; 1: many relationship with the other fact tables 

 

I can create an ID to link , consists of a primary key , quarter Num and year but it is not good practice to link fact to fact , I am geting into realional modelling vs demensional ; it does give me the desired result 

 

Ideally if I had fact table D at the same ganular level as the others (datatime) all would be easy unfrotunetly it is outside of my control what I receive 

 

I could try using End Of Quarter date as a key , meesing around with max function ; not a nice solution 

 

Anybody come across a solution to this ?

 

 

 

 

 

3 REPLIES 3

I just get this error 

 

Capture.PNG

Hi.  @carlol 

Can you show the relationships you have currently established between tables in a screenshot?

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors