Forum Discussion
Anonymous
3 years agoNot applicable
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
- Greg_DecklerCommunity Champion
Anonymous See if this helps: