Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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:
I need to generate a list of Month names in another table as follows:
How do I do that in Power BI?
Thanks a lot in Advance!
Solved! Go to Solution.
@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])
Thanks a lot ! It was helpful!
@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])
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 50 | |
| 42 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 139 | |
| 128 | |
| 60 | |
| 59 | |
| 57 |