Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.