Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Previous Month Calculation Not working

Hey!

 

I am trying to get the previous date impressions and I am running into issues. I was able to calculate current month without a date table, but when I got to previous month I needed to add one, When I did and created a relationship between the two tables the data got messed up and was wrong.  I am essentially trying to do current month - previous month here is my formula for previous month, any help would be greatly appreciated!

 

Previous Month = Var Previous= CALCULATE(sum(Articles[UVM (Insights by Similarweb)]),PREVIOUSMONTH('Date'[Date]))
Return if( ISBLANK(Previous),0,Previous)

1 Reply