Forum Discussion
customized subtotal
Hello. I am fairly new to PowerBI. I am trying to build a matrix that has a subtotal where it only adds when "Weekday" is Monday through Friday. I already have subtotals which adds up all the days, b...
Greg_Deckler This is my data. I want to ultimately only add Monday through Friday and also have another total for Monday through Saturday. Is this possible?
| Month | Weekday | 8 | 9 | 10 | 11 |
| OCT | |||||
| Monday | 253 | 281 | 336 | 366 | |
| Tuesday | 227 | 347 | 452 | 460 | |
| Wednesday | 250 | 328 | 417 | 500 | |
| Thursday | 224 | 313 | 396 | 403 | |
| Friday | 199 | 357 | 373 | 358 | |
| Saturday | 24 | 47 | 38 | 100 | |
| Total Verified (M-F) | 1153 | 1626 | 1974 | 2087 | |
| Total Verified (M-S) | 1177 | 1673 | 2012 | 2187 | |
| NOV | |||||
| Monday | 188 | 217 | 284 | 305 | |
| Tuesday | 206 | 313 | 446 | 420 | |
| Wednesday | 183 | 256 | 429 | 402 | |
| Thursday | 177 | 218 | 295 | 258 | |
| Friday | 209 | 317 | 414 | 422 | |
| Saturday | 40 | 75 | 118 | 105 | |
| Total Verified (M-F) | 963 | 1321 | 1868 | 1807 | |
| Total Verified (M-S) | 1003 | 1396 | 1986 | 1912 |