Forum Discussion
Add year column
Hi Power BI experts :-) How do I allocate existing data to a year? Do I create a new column in the Excel spreadsheet? Or the Query Editor? I've created a dashboard from an Excel spreadsheet o...
This question was solved by Ashish. The solution can be found here:
Hi, I am new in this topic, but I found a solution.
please review the file shared.
https://drive.google.com/file/d/18HbGmC1Z-hi1M6Xzn8gWuY2Tl-UpBpr2/view?usp=sharing
ready!
DanielRodriguez thanks for your effort. It's not quite what I'm looking for.
My column headings should be:
Year, DHB, Population, Enrolled, Base Population
Please see the Edit Query screenshot above.
I had a nice flat table in PBI until I added the year column in order to make a time trend line graph.