Forum Discussion
Sean2
6 years agoHelper I
Column for each year?
I have one large query that spans over several years and I would like to create a table like the one below. I'm thinking I need to create custom columns for each year. I have a date field that shows all entries. Is this the right approach and if so what DAX would I use to create theses custom columns?
Thanks.
| 2018 | 2019 | 2020 | |
| Activty 1 | |||
| Activty 2 | |||
| Activty 3 | |||
| Activty 4 | |||
| Activty 5 |
You can display like that in Matrix visual?
2 Replies
- amitchandakSuper User
You can display like that in Matrix visual?
- Sean2Helper I
Wow. I can't belive I missed that very useful visualization. Thank You very much.