Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone, after one day trying all suggestions on this forum I will ask for help because I cant find the solution for something that seems simple.
To create a cohort matrix I need a column with the total of the month
the table shouldlook like these
Thanks for help.
Solved! Go to Solution.
Hi diogonesbitt,
I have already added the year column as a filter in the formula, so it will only calculate the value within the same year range, and if you woud like to sum the value in month range, create a column which format with year and month with the date column, then use that column as a filter.
GroupTotal = sumx(
filter(
'Table',
And('Table'[Mes]=earlier('Table'[mes]),
‘Table’[Ano]=Earlier(‘Table’[Ano]))
),
'Table'[Count of id])
Regards
I don't see your image. Sample data would be great too.
Hi diogonesbitt,
We could create a calculated column to calculate the group total, with the formula below:
GroupTotal = sumx(
filter(
'Table',
And('Table'[Mes]=earlier('Table'[mes]),
‘Table’[Ano]=Earlier(‘Table’[Ano]))),
'Table'[Count of id])
Check to see if this would meet your requirements.
Regards
Hi Michael, Thanks for reply,
The problem is that in thant case May 2015 will sum with may 2014. I'm I wrong?
Hi diogonesbitt,
I have already added the year column as a filter in the formula, so it will only calculate the value within the same year range, and if you woud like to sum the value in month range, create a column which format with year and month with the date column, then use that column as a filter.
GroupTotal = sumx(
filter(
'Table',
And('Table'[Mes]=earlier('Table'[mes]),
‘Table’[Ano]=Earlier(‘Table’[Ano]))
),
'Table'[Count of id])
Regards
Thanks Michael it works.
But I still have 1 question,
I cant user the 'Table'[Date].MonthNum instead new column called 'Table'.[Month]. Why?
Hi,
What " 'Table'[Date].MonthNum " indicates here, and how it works?
Could you please share the formula reference here?
Regards
Hi everyone, after one day trying all suggestions on this forum I will ask for help because I cant find the solution for something that seems simple.
To create a cohort matrix I need a column with the total of the month
the table shouldlook like these
Thanks for help.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |