Trouble Grouping records in a matrix

[Anonymous]

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;

Any ideas?

Thanks, Steve

[Anonymous]

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 · Accepted solution]

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...