Forum Discussion
Question regarding the matrix table
Anonymous - Perhaps have a look at The New Hotness - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
Community ChampionAnonymous - Perhaps have a look at The New Hotness - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
Greg_Deckler
I believe the information on your link is what i was looking for. However, could you explain me a little bit more regarding this dax
Custom Hierarchy =
{
("2019", "January", 1),
("2019", "February", 2),
("2019", "March", 3),
("2019", "April", 4),
("2019", "May", 5),
("2019", "June", 6),
("2019", "July", 7),
("2019", "August", 8),
("2019", "September", 9),
("2019", "October", 10),
("2019", "November", 11),
("2019", "December", 12),
("2020", "January", 1),
("2020", "February", 2),
("2020", "March", 3),
("2020", "April", 4),
("2020", "May", 5),
("2020", "June", 6),
("2020", "July", 7),
("2020", "August", 8),
("2020", "September", 9),
("2020", "October", 10),
("2020", "November", 11),
("2020", "December", 12),
("Other", "LY", 13),
("Other", "PY", 14)
}
I'm wondering how do I implement this on my report.