The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
@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...
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 |
@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.
@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.