Calculated Calendar

[R_]

Hi All,

We have snapshot Amount in our Data Model.

 

So, I have to create a calendar which automatically takes the last date amount of month/year if I have to calculateas below:

If(Calendar(Month) = Jan, Sum(Amount)) = (Result should be as 3000 )

&

If(Calendar(Year) = 2017, Sum(Amount)) = (Result should be as 5000)

Regards,

R_

[Phil_Seamark]

HI @R_

Can you please post a sample of what you expect your output to look like?

eg, do you just want 2 rows for your example data or still have 8 rows?