The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, first time post here so be kind!
I am trying to create a Power BI report which will show a cost attribution per year of a contract. I know the start and end date of a contract so know how many months overall but the contract may start and end mid year so it is not as simple as dividing the number of months by 12. example:
contract starts on 1st April 2023 and ends 31st Match 2026 and the value of the contract is $18000. The financial year for the business is starts in December and runs to November the following year.
What I want to be able to calculate is how much of the contract values falls into each FY. so FY2023 will be April - November so it is nine 36ths as there are nine months of the FY left for a 36 month contract.
what I'm struggling with is how to establish a formula(s) which will calculate this so I can present how much contract value will be realised in each FY.
Has anyone tied to do anything like this and have a suitable solution?
Thanks in Advance
Andrew
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |