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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SeGr
Helper I
Helper I

month total and year total in the same matrix

hi,

 

I need a table the following columns in the same matrix table:

SeGr_0-1663161012852.png

W1 ...W 4 are sum(measure)

Month total = sum (visible weeks e.g. w1 .... w4)

YTD = YTD calculation

 

How can I show this in one matrix?

5 REPLIES 5
SeGr
Helper I
Helper I

@amitchandak , sure. basically, I need to be able to add ANY calculation in the same matrix visual. I do not have any sample PBIX, unfortunately...

@SeGr , Can share sample in table format, how your raw data looks like

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

datevalue
1/1/202276
1/2/202219
1/3/202286
1/4/202268
1/5/202237
1/6/202284
1/7/202268
1/8/202217
1/9/202214
1/10/202284
1/11/202266
1/12/202240
1/13/202282
1/14/202217
1/15/202297
1/16/202242
1/17/202245
1/18/202299
1/19/202278
1/20/202260
1/21/202290
1/22/202233
1/23/202212
1/24/202259
1/25/202291
1/26/202279
1/27/202283
1/28/202269
1/29/202226
1/30/202226
1/31/202233
2/1/202237
2/2/202217
2/3/202293
2/4/202258
2/5/202279
2/6/202271
2/7/202239
2/8/202256
2/9/202260
2/10/202228
2/11/202288
2/12/202255
2/13/202252
2/14/202210
2/15/202270
2/16/202212
2/17/202284
2/18/202239
2/19/202259
2/20/202216
2/21/202293
2/22/202238
2/23/202255
2/24/202220
2/25/202213
2/26/202280
2/27/202238
2/28/202272
3/1/202253
3/2/202222
3/3/202263
3/4/202232
3/5/202290
3/6/202275
3/7/202251
3/8/202263
3/9/202297
3/10/202298
3/11/202295
3/12/202292
3/13/202269
3/14/202255
3/15/202211
3/16/202244
3/17/202276
3/18/202260
3/19/202235
3/20/202245
3/21/202272
3/22/202287
3/23/202288
3/24/202244
3/25/202274
3/26/202277
3/27/202249
3/28/202227
3/29/202233
3/30/202265
3/31/202231
4/1/202240
4/2/202256
4/3/202298
4/4/202261
4/5/202283
4/6/202233
4/7/202254
4/8/202270
4/9/202250
4/10/202232
4/11/202248
4/12/202211
4/13/202258
4/14/202242
4/15/202246
4/16/202244
4/17/202274
4/18/202277
4/19/202292
4/20/202289
4/21/202292
4/22/202265
4/23/202270
4/24/202241
4/25/202293
4/26/202238
4/27/202230
4/28/202227
4/29/202222
4/30/202285

@SeGr , Have date table with month and year.

 

Total = sum(Table[value])

 

Final measure =

Switch(True() ,

isinscope(Date[Week]) || isinscope(Date[Month]), [Total] ,

isinscope(Date[Year]), calculate( [Total], datesytd(Date[Date]) ))

 

 

Assuming week, month and year from date table has been used in matrix column

 


To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
amitchandak
Super User
Super User

@SeGr , If you have Year, month on column of Matrix, you should also get year total , once months are over

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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