Forum Discussion
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 0 represents the current month.
My problem is: In the table of my report I want the name of months that appears and not the numbers.
Taking into account that from one month to another the period 0 will change according to the current month. I created a table in wich the first column there is Periods from 0 to 12 and I wanted that in the second column I put = Month(today()). But the formula was not accepted.
I was thinking about defining a parametre that will be asked to the user when he opens the report. He enters the number of the current month and it will genererates in my table the name of the month. But I don’t know how to do it. Do you have any other suggestions please?
Thank you for your help !
1 Reply
Afef 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
