Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
R_
Regular 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
Employee
Employee

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.