Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Thanks in advance and I appreciate any help on this.
I'm trying to calculate the marketing spend per month/quarter, as to be used in a budget tracker. A contract is signed on the signed date for a contracted amount and runs from the signed date to contract end date. Our objective is to spend the entire contract amount during the duration of the contract. The tracker shows the planned amounts that needs to be spent per month and quarter.
Criterias:
I have two data sets.
1. Opportunity, with information regarding the client and contract. Important numbers are Signed Date, Contract end date and Contract amount.
2. Spent Funds, shows between what dates the contracted amounts were spent. Start Date, End Date and Spent Amount.
The two tables are linked by the Opp ID. All dates are european format, YYYY-MM-DD.
The expected outcome is something similar to this. With the current quarter being Q2. (to be taken in to account for the signed date.)
Link to Pbix file.
https://drive.google.com/file/d/12L9iKdDf76imDzz0XlkcO5KW9jl4eEsr/view?usp=sharing
@Anders_G , Refer if these two can help
or
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
Thank you, I will have a look and see if they will help.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |