Forum Discussion
How to group multiple variables into years?
The solution would in line with the solution in the blog
But will need more logics.
If possible please share a sample pbix file after removing sensitive information.Thanks.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
I should note that I do have historical data for years 2010-2019 saved in an excel sheet from old reporting methods, so if there's an easy way to automatically add to that every new year and save it, instead of generating the historical yearly data from a Power BI query, I could do that instead.
- amitchandak
Super User
The solution would in line with the solution in the blog
But will need more logics.
If possible please share a sample pbix file after removing sensitive information.Thanks.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601