cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Super User II
Super User II

Re: Last calendar months sale

@Grob2 

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

Highlighted
Helper I
Helper I

Re: Last calendar months sale

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
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021