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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MRUry7
Resolver II
Resolver II

Trouble Grouping records in a matrix

Hi, I have a list of records that I am trying to group by month.

Right now, i have a table below that shows the detail of each record.  The prevMonth is correct and the data shows everything properly.  Here's the formula I'm using

PrevMonth =
CALCULATE(Sum('DB - UserViews'[timebetween]),
    PREVIOUSMONTH('DB - UserViews'[Date]))


Everything is calculating as expected but if I try to group by Month, I visually lose the data in The PrevMonth Column.

My goal is that when I group by Month, the matrix above would show the aggregated result;

MRUry7_0-1686848645100.png

Any ideas?

Thanks, Steve

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You are grouping by week, not by month. Weeks and months are not compatible.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

View solution in original post

2 REPLIES 2
MRUry7
Resolver II
Resolver II

I"ll have to pass on this then. I'm currently unable to provide the details of this specific issue.  But I appreciate the effort!

lbendlin
Super User
Super User

You are grouping by week, not by month. Weeks and months are not compatible.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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