Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
11 months ago
Solved

How to create hierarchy not in fct table or based on integer key columns?

Hello, I have fct_table with integers keys to dim tables where my fields from hierarchy exists.  How to make hierarchies from there?  Currently I have string fields in fct_table and can crea...
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    10 months ago

    jaryszek ,

    Thank you for sharing your blog post.

     

    • The RELATED () function pulls data from a related table into the current one, typically used in calculated columns.
    • This operation is evaluated during data refresh, not during report interaction. So, it affects model processing time, not query performance.

     

    We appreciate your engagement and thank you for being an active part of the community.


    Best Regards,
    Lakshmi.

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
11 months ago

Hi jaryszek ,

Thanks for reaching out to the Microsoft fabric community forum.

 

Could you please provide sample data (Fact & Dim )that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format ( PBIX, Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.

Looking forward to your response.

 

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi