Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
some_bih both codes I shared on those two screenshots are OK, as I checked the results highlighted on the second screenshot and they are fine.
The problem is not with the code I've developed so far, since they get me 90% of the way to accomplish what I need.
My problem is getting the final 10% of the code that will get me there. I just don't know how to grab the results I calculated and get them to the rows they relate to on the fact table.
Maybe I didn't express myself right in the way I originally phrased my question and I apologize for that. I re-wrote the very end of the question to make my question/problem more clear.