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...
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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

 

 

If it is not your case, please share some data sample and expected output . You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

 

 

Best Regards,

Lin