Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Month over Month

Hello I am trying to show a month by month comparison betweeen total views. I have been looking at youtube and this channel as well for answers and im not sure if I dont have enough data or what exactly I am doing wrong. I only have 3 months worth of data so maybe thats my issue 

I started out with just one dataset "data" which has a column of "Total Views"

My first attempt i did:

 

tv = SUM(data[Total Views])
 
total views last month =
CALCULATE(
[tv],
PARALLELPERIOD(
'data'[Date].[Date],
-1,
MONTH)
)

but i just get the exact same number for that month when trying to graph it ot show it in a table
Screenshot_46.jpg
also tried this code:
total by month LM = CALCULATE(SUM(data[Total Views]),DATEADD(data[Date].[Date],-1,MONTH))
 
but gives me the same results 
Screenshot_47.jpg
also tried 

PrevMonthRev = CALCULATE(sum(data[Total Views]),PREVIOUSMONTH('data'[Date].[Date]))
but thats not even giving me any numbers 
 
tried 
last month = CALCULATE(SUM(data[Total Views]),DATEADD(data[Date].[Date],-1,MONTH),ALL(data[Date]))
 
and thats giving me the same numbers as well 
Screenshot_48.jpg
 
The end goal would be to have a bar chart that would show the difference between the current month and past month 
1 REPLY 1
colacan
Resolver II
Resolver II

@Anonymous Hi Johnny, when I faced the same issue (where the current month value and previous month value are the same) under such a simple time function, there was issue with either date table or date column. I recommend to double check them. or please share sample data.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.