Forum Discussion

tonijj's avatar
tonijj
Icon for Helper IV rankHelper IV
9 years ago
Solved

Start Date to End Date - Populate/Generate values inbetween

Hi,    I've been trying to find a solution to this in the forum for quite some time now, but the Time Intelligence threads out there are a bit similar but doesnt really aim at my specific issue.  ...
Need Help
Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
9 years ago

Hi tonijj,

 

Please accept my 1st answer as your solution and create a separate post for your 2nd need. 

This will help people find the most relevant answers.

 

parry2k 's suggestion looks good :)

tonijj's avatar
tonijj
Icon for Helper IV rankHelper IV
9 years ago

OK will take care of that now!

 

Understand that I should probably create a new post, but after a long day of Excel and DAX Im not sure I got it in me :/

 

But, the way I see it, it shouldnt be using Average at all, but rather something like:

 

Sum of Utilization / Total SUM of days


I think, but hey... its soon time to give up for today