Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jfaurschou
New Member

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
0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.