Skip to main content
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


Data Flow and Fact Tables

I have several tables of facts, sales, hours, and a flow with employees and their superior. The employee can change over the course of the time of the superior, I want to know the superior at all times of the sale, I don't want to do it by var in the fact tables, but in a summary table that I have where the employees appear to me only once. How can I do that? Since it gives me the current superior, but if I filter by previous months in the visual, it doesn't give me the previous one but always the current one.

Super User
Super User

@Syndicate_Admin , Do you have SCD employee dimension?


Refer video from Guyincube -



No, it doesn't.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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