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 September 15. Request your voucher.
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
User | Count |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
13 | |
7 | |
5 |