Forum Discussion
Setting Custom Dynamic Quarters
The last part of the EDATE is the number of months to adjust by and we want values 0, 3, 6 and 9.
[Quarter budget] * 3 should be TableName[Value] * 3
PS it helps readability / understanding to qualify column names with their tablename first.
Thanks, Brian
Hi Brian,
I have attached some screenshots to try and help. The first one shows the new calculated table you helped me to create, which has worked out the quarters perfectly. I've then shown the relationships from this new table to my date table, and from my actuals table (Instructions) to my date table. I've then shown the table I am trying to present and what it is in it.
The quarter budget part of the table works perfectly, the count of property ID (which is my actuals) doesnt. Becuase the dates of the quarters are single dates (1/11/19, 1/2/19 etc.), then the actuals are only picking up when the date is exactly them and not anything in between.
For example on the table i have shown, there should be 2 in the first actual box, they have came from the 5th & 6th of November. But because they arent the first then they are not showing in the quarter.
I can't work out how to make it so the actuals count from the 1/11/19 all the way up until the end of Jan for Q1, instead of just looking at 1/11/19.
I hope this makes sense
thanks