Forum Discussion
Creating a Normalized Tabled with daily rows over the course of a year
- 8 years ago
Although I had a couple users help me out with this, no one really got me the solution I was looking for. I ended up sorting it out on my own as follows:
1. Manually (what I was trying to avoid) created a "Normalized" tab in my data source, excel and copy/pasted the data from each year into it's own column. Created a column along the left numbered 1 - 365 to represent the days of the year (there doesn't seem to be a date format allowing no year to be represented).
2. Within PowerBI generate a "Running total" measure using the category of interest and "Day of Year" which is what I'd called the numbered day column
Then you are able to plot multiple categories on one graph as follows:
Idealy I'd like to have the numbers at the bottom show up more like Jan 1, Feb 1, March 1, etc. but am not sure how. For the mean time this is a 90% solution to my original problem.
Hi Bila,
Thanks for your help I think this table looks like what I'd like. I've created a NoOfYear column with my expenses table, now on the new table am I able to duplicate that column and then put the cumulative data beside it?
I'd like to relate the categorical data back to the day but grouped in columns by each year, example here: