cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
R_ Frequent Visitor
Frequent Visitor

Calculated Calendar

Hi All,

 

We have snapshot Amount in our Data Model.

 2Capture.JPG

 

                                                                                                         

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_

1 REPLY 1
Phil_Seamark Super Contributor
Super Contributor

Re: Calculated Calendar

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?

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!