Forum Discussion

Sean2's avatar
Sean2
Helper I
6 years ago
Solved

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.

 

 201820192020
Activty 1   
Activty 2   
Activty 3   
Activty 4   
Activty 5   

2 Replies

    • Sean2's avatar
      Sean2
      Helper I

      Wow. I can't belive I missed that very useful visualization. Thank You very much.