Forum Discussion

NipponSahore's avatar
NipponSahore
Icon for Resolver II rankResolver II
10 years ago

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...
Need Help
Tutorial Requests
dataloreous's avatar
dataloreous
Icon for Advocate III rankAdvocate III
7 years ago

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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?