The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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_Capacity
DL_V_Realisasi_Produksi/DL_V_Production_Realization
Dim_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.
Does anybody know how to solve this problem? I need your all help and tutorial how to fix this. Thank you guys