Forum Discussion
Afef
7 years agoNew Member
Monthly Report
Hi every one, Could you please help me with an issue. I have data that will be updated every month. Using this Data I generate a monthly report. In the data, there is periods from 0 to 12. Period...
henriquesilveir
Resolver IV
7 years agoAfef hello, you can create a Dim Calendar.. it will help you to got month names.
To create a Dynamic dim calendar use this article: https://techcommunity.microsoft.com/t5/BI-and-Data-Analysis/Use-Power-Query-to-create-a-Calendar-for-Power-BI/td-p/67657
Or you can do it using the Power Query Editor > Add Column > Date > Month > Name of MonthPower Query Editor > Add Column > Date > Month > Name of Month