Forum Discussion
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...
Hi Raj, see my screen capture below. I need to use a measure otherwise i get a 'circular reference' error.
hi, SpaceCat42
These two formulas work well for create the measure
and do not use them to create the column.
Reference:https://www.sqlbi.com/articles/understanding-circular-dependencies/
Best Regards,
Lin