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.
Dear all,
I'm stuck.
I would like to calculate the SUM of savings that we have established in a specific year. This is working for the savings start year, but the issue is when I have savings that for example start in 2019 and ending in 2020. Then the savings that are started in 2019 need to be added also in 2020.
Any idea?
Thanks for your feedback.
Kind Regards,
Frederik Bisback
Hello Amit,
Thanks for the reply.
I have added some value into the Power BI. I need also to have a view per year and the savings added when there are ending in that year. Hopefully, this is clear for you.
This is the link towards the file: https://1drv.ms/u/s!AkkrP0oP7IaagQY0mULXTk-Zx2UN?e=hn5SWE
@FrederikBisback ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
See my attached file after signature can help
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |