Forum Discussion
Helper IVStart Date to End Date - Populate/Generate values inbetween
Hi,
You need to use the Query Editor and the List.Dates function (M language).
You will find here my solution: https://1drv.ms/f/s!Ag8khmd3N7ExgQjuCxFseRnECYoh
Solution SageHi,
You need to use the Query Editor and the List.Dates function (M language).
You will find here my solution: https://1drv.ms/f/s!Ag8khmd3N7ExgQjuCxFseRnECYoh
tonijjHi,
So...wow!! I would never been able to figure that one out no matter how much I wouldve googled/read threads, a HUGE thank you for a superb solution!!!
I might as well ask as a quick followup question then, that has to do with the new Utilization. If we look at the picture below, it displays the individual items correctly, as it is an Average.
Question: How can I keep the Utilization (preferrably, but not necessary, to percent), BUT, making PowerBI add the two numbers to a total?
Since the report refers to being a utilization report of Consultants, in this case it would mean that John Doe is actually Utilizing 80% of his time (A + B ).
I understand that the total wont be "80" as long as I have it as an "Average", Im just asking how I should've set it up instead. I have tried several non-working solutions such as Count and divide it by the sum, but, Im just not getting there :(
Again, a big thank you! Please note that helpfulness as this really makes a difference for us still in an early learning curve, and its highly appreciated!
- parry2k
Super User
To your 2nd question, you need to create a summary table with average and you can use that for sum.
- Datatouille
- tonijj
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
Sir,
Is there a similar function for numbers? So, similar scenario, only no dates, but in stead a startnumber and endnumber. Does such function exist?
