cancel
Showing results for
Did you mean:
Regular Visitor

## 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 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))

5 REPLIES 5
Community Support

hi, @SpaceCat42

After my test, this formula works well,

if you want this new measure as below:

`new previous month = CALCULATE(SUM(Table1[Value]),PREVIOUSMONTH(Table1[Originated].[Date]),MONTH(Table1[Originated])=MONTH(TODAY())-1)`

For example:

basic data

Result:

here is pbix, please try it.

https://www.dropbox.com/s/mmccx2bj8bp470s/Previous%20Month%20Error%20using%20a%20Measure.pbix?dl=0

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Champion

@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

Regular Visitor

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

Community Support

hi, @SpaceCat42

These two formulas work well for create the measure

and do not use them to create the column.

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

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.

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors