Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Generating a List of Month Names between two dates

Hello all,

 

I am new to Power BI and may be there is a simple solution that I am not familiar with.

I am trying to generate a list of month names in between a start date and end date from another table.

 

This is the table containing the start date and end date:

Sanath_95_0-1623923407687.png

 

I need to generate a list of Month names in another table as follows: 

Sanath_95_1-1623923515085.png

 

How do I do that in Power BI?

 

Thanks a lot in Advance!



1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous ,

a new table like

Table = SUMMARIZE(ADDCOLUMNS(CALENDAR(DATE(2019,12,01), date(2021,11,20)), "Month year", format([Date], "MMM-YYYY")), [Month year])

or

Table = SUMMARIZE(ADDCOLUMNS(CALENDAR(DATE(2019,12,01), date(2021,11,20)), "Month", format([Date], "MMM")), [Month])

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks a lot ! It was helpful!

 

amitchandak
Super User
Super User

@Anonymous ,

a new table like

Table = SUMMARIZE(ADDCOLUMNS(CALENDAR(DATE(2019,12,01), date(2021,11,20)), "Month year", format([Date], "MMM-YYYY")), [Month year])

or

Table = SUMMARIZE(ADDCOLUMNS(CALENDAR(DATE(2019,12,01), date(2021,11,20)), "Month", format([Date], "MMM")), [Month])

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.