Forum Discussion

SpaceCat42's avatar
SpaceCat42
Regular Visitor
7 years ago

Previous Month Error using a Measure

This works and returns the correct 'current month' values: Current Month Value = CALCULATE(SUM(Table1[Value]),MONTH(Table1[Originated])=MONTH(TODAY()))   Previous Month formula calculates every...
Anonymous's avatar
Anonymous
Not applicable
7 years ago
SpaceCat42 wrote:

This works and returns the correct 'current month' values:

  • Current Month Value = CALCULATE(SUM(Table1[Value]),MONTH(Table1[Originated])=MONTH(TODAY()))

 

Previous Month formula calculates every row with the correct amount. However i only want the row to populate if it mets the criteria of a "prevous month." Is there a simple fix here?

 

previous month = var current_month = MONTH(TODAY()) return CALCULATE(SUM('Table1'[Value]),FILTER('Table1',MONTH('Table1'[Originated])=current_month-1))

Bit confusing here. As per the blue highlight, your previous month measure works fine. What is your requirement ?

 

Thanks
Raj

  • SpaceCat42's avatar
    SpaceCat42
    Regular Visitor
    7 years ago

    Here's  a screen grab. Current Month colum is correct. The previous month column has the proper value, but its replicated itself across all the data rows.

  • SpaceCat42's avatar
    SpaceCat42
    Regular Visitor
    7 years ago

    Hi Raj, see my screen capture below. I need to use a measure otherwise i get a 'circular reference' error.