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.
Hoping someone can help. I've got stuck trying to do time-based analysis on the following table concerning carbon savings. An example of the table is below and also the closest DAX code used in a measure. The measure is not summing correctly.
[Carbon initiatives]
Initiaitve name | Start date | End Date | Daily tCO2e Saved | Total tCO2e Saved |
Carbon 1 | 30/6/18 | 31/12/20 | 0.0007099 | 0.6 |
Carbon 2 | 17/7/18 | 17/10/18 | 0.1681297 | 15.5 |
Carbon 3 | 1/1/17 | 31/12/19 | 2.2380404 | 2,448.4 |
Carbon 4 | 22/2/19 | 20/5/20 | 0.1425835 | 64.6 |
[Measure]
Year | tCO2e saved |
2017 | 649927.39 |
2018 | 793721.03 |
2019 | 483959.38 |
Any help much appreciated
Not 100% sure what you are going for but take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Year | tCO2e Saved |
2018 | 629.48 |
2019 | 708.15 |
2020 | 1.35 |
Year | tCO2e Saved |
2018 | 3,450 |
2019 | 4,807 |
2020 | 909 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
105 | |
101 | |
80 | |
67 |