Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Monthly Sum

Working towards building a formula, but I believe I need to do this in pieces so I'm not confusing anyone. I've asked this a few times and still haven't found my answer... So I will start simple: ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Anonymous

     

    Try putting the *12 after the last parenthesis.

     

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

 

Let's made a modification to the measure to be more simple

 

 

LastMonthRevenue_Reloaded =
VAR LastMonthRevenueDate =
    EOMONTH ( LASTDATE ( Table1[Revenue Date] ); 0 )
RETURN
    CALCULATE (
        SUM ( Table1[Revenue] );
        FILTER ( Table1; EOMONTH ( Table1[Revenue Date]; 0 ) = LastMonthRevenueDate )
    )

And -1 month:

 

LastMonthRevenue_Reloaded-1 =
VAR LastMonthRevenueDate_1 =
    EOMONTH ( LASTDATE ( Table1[Revenue Date] ); -1 )
RETURN
    CALCULATE (
        SUM ( Table1[Revenue] );
        FILTER ( Table1; EOMONTH ( Table1[Revenue Date]; 0 ) = LastMonthRevenueDate_1 )
    )

Regards

Victor

Lima - Peru

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Vvelarde These work perfectly. I really can't thank you enough! Thought I would never figure it out. Thanks again.