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.
Hi All, I have a situation where my report and visual are doing exactly what I want them to do, but I am trying to find another way that will be less of a burden on my data model and be faster for the user(s) of my report.
I want to look at services used over the life of a contract, and show the data as such. That is, a customer may pass the start date of their contract, but three months may go by before they consume any of their entitlement, so the graph should show zero for those months and those months only. For example, here is a contract that begins in December 2019. I do NOT want this where it shows all dates because the contract didn't begin until Dec 2019:
I only want where it shows the date the contract began as below.
The blue dotted line is what they are entitled to, while the purple line is their usage.
To accomplish this, and since I have contract start date and contract end date, I created a table called Contract Active Dates in Power BI with DAX. This creates a table that has a date and contract number for every single date a contract number is active:
@Shelley , refer to my blog around a similar topic if that can help
or video :https://youtu.be/e6Y-l_JtCq4
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |