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.
Hello everyone, and thanks in advance.
I have modeled a photovoltaic plant.
For the surplus energy that it exports to the grid, the company pays an amount, which I calculate with a measure: "Valor_exportación", reducing it from the payment for imported energy in deficit hours "Valor_importación", with the payment for the surplus limited to the value of what was imported in the monthly calculation. The model is calculated hour by hour with a hierarchy of DateTime Year-Month-Day. I need a measure that adds, for the selected period, the net value of the energy exported (Valor_exportación limited in the monthly calculation to the Valor_importación)
Can anyone help me?
Thanks a lot
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.