Forum Discussion
Helper IIRolling up dates in Excel pivot from Power BI data
Hi Anonymous
In the link it is a single table with columns for each date category such as Year, Month, Day and Date
You can then just drag in the year to get the data to aggregate by year.
Hi GilbertQ ,
I do have the table set up as a date table (by using a continuous date range and setting the "Mark as date table" option), but I'm still not able to roll up the dates. In the link you posted, they have individual dimensions for year, month, etc. in the table. That was sort of my question -- is it required to have everything broken up at that level in the date table in order to allow users to pivot the data in Excel by year and month? Or is there a way to just provide a single date dimension where the user can decide which granularity of time period they want to roll up to (similar to how a standard pivot would work with Excel data).
Super UserHi Anonymous
In the link it is a single table with columns for each date category such as Year, Month, Day and Date
You can then just drag in the year to get the data to aggregate by year.