Forum Discussion
Return Hours for Calendar Day
Hi - I have searched high and low for this answer, but I can't seem to make any of the solutions work. I have the data in the table below, having used the Divide and DateDiff to give me an HoursPerD...
AlexanderPrime
Solution Supplier
Solution SupplierIt's essentially calculating and assigning to an hour per day to an individual calendar date for each of your assignment IDs.
For example, in your first row on that screenshot you provided, that will generate 7 rows, one for each date between 16th and 22nd of August. If you have a bunch of long term assignments in there then it's going to generate a lot.
Yep - I've added
&& 'Calendar'[Date] >= (TODAY()-120) &&
'Calendar'[Date] <= (TODAY()+120) to at least limit back down to 75000 rows at this stage.
I am now getting a circular dependancy error when I try to create a relationship to a higher level planning table so I'll need to solve for that as well.
Thanks
I am now getting a circular dependancy error when I try to create a relationship to a higher level planning table so I'll need to solve for that as well.
Thanks