Forum Discussion
Solved
Custom Adding Columns in a Matrix
A. Current Matrix "Sales of Food by Day of Week " - Rows: Food dimension - Columns: Date dimension - Values: [Sales] measure B. Wanted Result - Same Rows and [Sales] measure . - ...
By creating a 2nd day type, weekend/weekday, you can put both into the column part of the matrix and get this result. Will that work?
My fields are as follows:
See my PBIX file on how I did this. There is a full date table here and I added the Day Type column. If the day is SatSun, then Weekend, else Weekday.
NOTE: I just did this with the June 2021 Power BI desktop, so if you get an error when opening try and click through it, or upgrade.
Thanks edhans for your short workaround, it gives the expected sub-total columns.
Great! Glad I was able to help mybarbie9917