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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

See blank for values that doesn't match Dim Table

Hello.

I have a model with two tables:
Fact Table of Revenue (a), with 2 columns:
1.DepartmentCode
2.Revenue

 

Dim Department Table (b) with 2 columns:
1.DepartmentCode
2.HeadofDepartment

 

They are relationated by DepartmentCode column, with Fact Table being filtered by Department Table.

 

The question I'm facing is: my FactTable of revenue is updated everyday and can have new departmentcods that aren't in my Department Table yet (this table is updated manually as I realize we have new deparments in the fact table).

Does someone know how could I create a table with all departments code, its revenue and its Head of Department but showing also the departments withou Heads?

2 REPLIES 2
Anonymous
Not applicable

Hi.
Both table are in direct query. 

 

Thank you, Antonio

AmiraBedh
Resident Rockstar
Resident Rockstar

How are you loading your data in Power BI ?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.