Forum Discussion
Create columns for each month
Hello,
I have a document with a bunch of transactions, and have one column that show the month of each transaction (please refer to the picture attached).
I am trying to find a way on which I can create a column for each Month. And I want that column to show all the transactions details.
I was trying to use summarize but didn't really find anything.
Thanks in advance!
Anonymous do you want across all the year for each month or each month of each year.
You can add following column in your model and then use that to visualize
Month Year = FORMAT( Table[Txn Date], "MMM, yy" )
5 Replies
Anonymous do you want across all the year for each month or each month of each year.
You can add following column in your model and then use that to visualize
Month Year = FORMAT( Table[Txn Date], "MMM, yy" )
Anonymousso what I proposed should work.