month total and year total in the same matrix

[SeGr]

hi,

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

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?

[SeGr]

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

[amitchandak]

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

[SeGr]

date	value
1/1/2022	76
1/2/2022	19
1/3/2022	86
1/4/2022	68
1/5/2022	37
1/6/2022	84
1/7/2022	68
1/8/2022	17
1/9/2022	14
1/10/2022	84
1/11/2022	66
1/12/2022	40
1/13/2022	82
1/14/2022	17
1/15/2022	97
1/16/2022	42
1/17/2022	45
1/18/2022	99
1/19/2022	78
1/20/2022	60
1/21/2022	90
1/22/2022	33
1/23/2022	12
1/24/2022	59
1/25/2022	91
1/26/2022	79
1/27/2022	83
1/28/2022	69
1/29/2022	26
1/30/2022	26
1/31/2022	33
2/1/2022	37
2/2/2022	17
2/3/2022	93
2/4/2022	58
2/5/2022	79
2/6/2022	71
2/7/2022	39
2/8/2022	56
2/9/2022	60
2/10/2022	28
2/11/2022	88
2/12/2022	55
2/13/2022	52
2/14/2022	10
2/15/2022	70
2/16/2022	12
2/17/2022	84
2/18/2022	39
2/19/2022	59
2/20/2022	16
2/21/2022	93
2/22/2022	38
2/23/2022	55
2/24/2022	20
2/25/2022	13
2/26/2022	80
2/27/2022	38
2/28/2022	72
3/1/2022	53
3/2/2022	22
3/3/2022	63
3/4/2022	32
3/5/2022	90
3/6/2022	75
3/7/2022	51
3/8/2022	63
3/9/2022	97
3/10/2022	98
3/11/2022	95
3/12/2022	92
3/13/2022	69
3/14/2022	55
3/15/2022	11
3/16/2022	44
3/17/2022	76
3/18/2022	60
3/19/2022	35
3/20/2022	45
3/21/2022	72
3/22/2022	87
3/23/2022	88
3/24/2022	44
3/25/2022	74
3/26/2022	77
3/27/2022	49
3/28/2022	27
3/29/2022	33
3/30/2022	65
3/31/2022	31
4/1/2022	40
4/2/2022	56
4/3/2022	98
4/4/2022	61
4/5/2022	83
4/6/2022	33
4/7/2022	54
4/8/2022	70
4/9/2022	50
4/10/2022	32
4/11/2022	48
4/12/2022	11
4/13/2022	58
4/14/2022	42
4/15/2022	46
4/16/2022	44
4/17/2022	74
4/18/2022	77
4/19/2022	92
4/20/2022	89
4/21/2022	92
4/22/2022	65
4/23/2022	70
4/24/2022	41
4/25/2022	93
4/26/2022	38
4/27/2022	30
4/28/2022	27
4/29/2022	22
4/30/2022	85

[amitchandak]

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

[amitchandak]

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