Forum Discussion
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:
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!
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])
2 Replies
- amitchandak
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])