Forum Discussion

jfaurschou's avatar
jfaurschou
New Member
3 years ago

Report Due Dates Automatically for capacity Planning.

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 DueFinish Date Miles 
12345NC301/1/202310.1
54321LGY602/14/202313.4
23456

NFR

1203/14/2023128.5
34567NFR2904/28/20230.04
7895NC606/12/202369.2
69692LGY307/27/202366
9292LGY1209/10/202319.57
269992NFR26010/25/202363.64
No RepliesBe the first to reply