Formula PREVIOUSMONTH & DATESYTD

[EZV12]

Hello,

I have an issue with the combinasion of formulas PREVIOUSMONTH & DATESYTD. I need the YTD Sum of previous month's value & current month's value.  Here below are the formulas:

Sum Inventory PreviousMonth = CALCULATE ([Sum Inventory], PREVIOUSMONTH('Calendar'[Date])) 

Sum Inventory PreviousMonth YTD = CALCULATE([Sum Inventory PreviousMonth], DATESYTD( 'Calendar'[Date] ))

The result of "Sum Inventory PreviousMonth YTD" is not correct, there is only the value of previous month instead of the YTD SUM of value of previous month & value of current month.

Can anybody help?

Thanks and best regards

[CNENFRNL · Accepted solution]

Your measure,

Sum Inventory PreviousMonth YTD =
CALCULATE( [Sum Inventory PreviousMonth], DATESYTD( 'Calendar'[Date] ) )

=
CALCULATE(
    CALCULATE( [Sum Inventory], PREVIOUSMONTH( 'Calendar'[Date] ) ),
    DATESYTD( 'Calendar'[Date] )
)

obviously, inner filter PREVIOUSMONTH overrides outer DATESYTD.

You may want to try,

=
CALCULATE(
    CALCULATE( [Sum Inventory], DATESYTD( 'Calendar'[Date] ) ),
    PREVIOUSMONTH( 'Calendar'[Date] )
)

[EZV12]

Thank you very much for your help!

Best regards

[parry2k]

@EZV12 why you are using the Previous month measure in DATESYTD why not just do 

CALCULATE ([Sum Inventory], DATESYTD('Calendar'[Date])) 

What you are trying to achieve?