Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello -
I have a dataset for work that we perform throughout the year. With each job there is an associated Analysis report that is worked on and submitted within a given time frame (typically 30/60/90/120 Days after the finish date depending on the scope of the project.) Fairly new to PowerBI, but am looking to have a visual for planning purposes so we can see how our analysis needs are going to be throughout the year and plan around those needs.
Would like to see how many reports will be due each month based on the due date and list it out by technology and miles assocaited with each.
Any help would be great.
Sample Data
Invoice # | Technology | Final Report Due | Finish Date | Miles |
12345 | NC | 30 | 1/1/2023 | 10.1 |
54321 | LGY | 60 | 2/14/2023 | 13.4 |
23456 | NFR | 120 | 3/14/2023 | 128.5 |
34567 | NFR2 | 90 | 4/28/2023 | 0.04 |
7895 | NC | 60 | 6/12/2023 | 69.2 |
69692 | LGY | 30 | 7/27/2023 | 66 |
9292 | LGY | 120 | 9/10/2023 | 19.57 |
269992 | NFR2 | 60 | 10/25/2023 | 63.64 |
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |