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
Anonymous
Not applicable

Last calendar months sale

Hi,

 

I am looking for a way to sum last 3 month sales. The trick is to add up from the first day of the month three years ago to selected day.

Is there a better way to write this measure? it seems not really great (but works).

Last 3 calendar month sale = 
CALCULATE (
        SUM ( Sales[TurnoverinUnit] );
        DATESBETWEEN (
            'Date'[Date];
            STARTOFMONTH(DATEADD( 'Date'[Date]; -3; MONTH ));
            MAX ( 'Date'[Date] )
        )
    )

Thanks!

2 REPLIES 2
az38
Community Champion
Community Champion

@Anonymous 

why dont you like it? 🙂 easy and light enough from my point of view


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

Oh just I thought there will be a better way (e.g. using a prebuilt DAX formula) to manage it.

But if not, I will accept its fate.

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.

Top Solution Authors