Calculated Calendar

Question

Hi All,&nbsp;We have snapshot Amount in our Data Model.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;So, I have to create a calendar which automatically takes the last date amount of month/year if I have to calculateas below:&nbsp;If(Calendar(Month) = Jan, Sum(Amount)) = (Result should be as 3000 )&amp;If(Calendar(Year) = 2017, Sum(Amount)) = (Result should be as 5000)&nbsp;Regards,R_

phil_seamark · Answer

HI&nbsp;R_&nbsp;Can you please post a sample of what you expect your output to look like?&nbsp;eg, do you just want 2 rows for your example data or still have 8 rows?&nbsp;

Forum Discussion

Calculated Calendar

1 Reply

Related content

Calendar Slicer with Different Business Calendars

Custom calendar

Tweaking Financial Calendar

Fiscal Calendar Month Calculation

Weeknum as per Calendar