Forum Discussion
NipponSahore
Resolver II
Resolver IIDrill by decade
Hi Guys, I'm quite new to PowerBI and i was wondering if there is any way to Drilldown an Year value by decade. I have a sample dataset of IMDB top 250 movies and want to drill down by decade, b...
Greg_Deckler
Community Champion
Community ChampionYou should be able to create a new column like:
Decade = ROUNDDOWN(([Year]-2000)/10,0)*10
Obviously, you'll have to account for 1900's movies, you could do that in an if statement or I'm sure there is a nifty math solution.