All month by a particular year in a table

[Alex_Hasan]

Hello, I want to show this table like April-2005, May-2005...... How to do that? 

[Alex_Hasan]

It worked. Thank you so much 😀

[speedramps · Accepted solution]

Create a calandar table in Power Query with

• Date (contiguous dd/mm/yyyy from 01/01/2005 to 31/12/2014)
• Month year (month & "-" year eg April-2004, August-2005)
• Month year sort(Month number & "."  & year eg 01.2005, 02/2005

Filter just top row

In Data modeller click on Month year and sort by Month year sort

Delete filter on top row (so all rows are shown)

Drag month year to visual table and it will display in the desired sequence

Please click thumbs up and acept as solutiion button 😀

Watch these free videos for more help about calendars

Click here for videos