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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ohohbudi
Frequent Visitor

Relationship Between 1 Fact Table, 1 View Table with 1 Dim table

Hi guys, I'm from Indonesia & want to ask and need your all help immediately. Thank you

 

I have 1 fact table here : DL_Fact_Kapasitas_Mesin = DL_Fact_Machine_Capacity

I have 1 view table : DL_V_Realisasi_Produksi = DL_V_Production_Realization 

I have 1 dim time table : DL_Dim_Time 

 

and i want to connect "Tanggal Rencana Selesai Proses" which is in Date format (format : MM/DD/YYYY ) in DL_Fact_Machine_Capacity and "Tanggal Rencana" which is in date format (format : MM/DD/YYYY) to time (format ex: MM/DD/YYYY) as follows :

DL_Fact_Kapasitas_Mesin/DL_Fact_Machine_CapacityDL_Fact_Kapasitas_Mesin/DL_Fact_Machine_CapacityDL_V_Realisasi_Produksi/DL_V_Production_RealizationDL_V_Realisasi_Produksi/DL_V_Production_RealizationDim_TimeDim_Time

I can make relation between "time" (in date format) in DL_Dim_Time with "Tanggal Rencana Selesai Proses" (in date format MM/DD/YYYY) 

 

But I cannot make relationship between "tanggal rencana" (in date format) from DL_V_Realisasi Produksi with my DL_Dim_Time and the relationship cannot be activated and appeared that yellow warning.

relation.png

 

Does anybody know how to solve this problem? I need your all help and tutorial how to fix this. Thank you guys

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors