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...
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!