Forum Discussion
Drill 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...
You 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.
Here is a nifty math solution which accounts for both centuries :)
Decade = VAR DecadeStart = 'Date'[Year] - MOD ( 'Date'[Year], 10 ) VAR DecadeEnd = DecadeStart + 10 RETURN DecadeStart & " - " & DecadeEnd
How do I show, in a table, the highest rated movie / highest ranked movie in each decade? What about top 2 in each decade?
Also, how do I highlight the decades in which the top 3 movies were released?
