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
Howdy,
I have a list of contract details for our organisation. Included is the supplier name, description, start and end date, and value of the contract.
I need to analyse the suppliers using a daily contract value basis to determine the shape of their overall contract 'run-off'.
By this I mean, some suppliers have many contracts that start and end at different dates. For Supplier A, I want to be able to graphically show the contract profile (from today going out 2 years) of all their contracts on a daily basis - and compare this to Supplier B. Note that some contracts expire soon, others will go out beyond 2 years. When I compare the shape of the contract run-off between Supplier A and Supplier B, there should be a difference.
Question:
When I have a fact table with key contract data (supplier, value, start date, end date, cost centre), should I create a new table that has the daily contract spend for a date range out for 2+ years.
Is there a better way to solve this..?
Appreciated.
Solved! Go to Solution.
HI @Sentry,
It sounds like you want to analysis rolling amount on date axis based on two data fields and group by suppliers.
If this is a case, I'd like to suggest you create a calculate table to expand these date range and mapping to the original table. You can simply create a line chart to analyze records based on new table date range.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
HI @Sentry,
It sounds like you want to analysis rolling amount on date axis based on two data fields and group by suppliers.
If this is a case, I'd like to suggest you create a calculate table to expand these date range and mapping to the original table. You can simply create a line chart to analyze records based on new table date range.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
Please refer if this can help you in handling start and end dates
HR-Analytics-Active-Employee-Hire-and-Termination-trend
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
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 |
---|---|
98 | |
94 | |
87 | |
70 | |
65 |
User | Count |
---|---|
244 | |
127 | |
119 | |
81 | |
78 |