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:
I guess the best way is to add year column in excel sheet, although you can still create column in powerbi and assing year value to it but you have to put the logic which year value to assign to each row, so coming from excel will make it easy.