Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I like to divide SumTenantKWH with SumUtilityKWH from from image , which is already calculated measure
for each Facility from 2 different output tables (TenantKWH,UtilityKWH)
From the image
facility=DFW01 SumTenantKWH(4681698.36) / facility=DFW01 SumUtilityKWH(7,339.50) = 628.4581
facility=IAD01 SumTenantKWH(49,742,427.00) / facility=DFW01 SumUtilityKWH(64,619,748) = 0.769771
Any help will be appreciated...
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kindly see the comments below.