Question: Use MS SQL Server Analysis Service of the Tabular Model Or PowerPivot (Not the Cube Technique) to create range values as following for the Year

Use MS SQL Server Analysis Service of the Tabular Model Or PowerPivot (Not the Cube Technique) to create range values as following for the Year Opened of the Reseller in DB661 database.

Year Opened

Year Range

Between 1970 and 1974

Between 1970 and 1974

Between 1975 and 1979

Between 1975 and 1979

Between 1980 and 1984

Between 1980 and 1984

Between 1985 and 1989

Between 1985 and 1989

Between 1990 and 1994

Between 1990 and 1994

Between 1995 and 1999

Between 1995 and 1999

>=2000

After 2000

  • Ensure that Year Range should be in ascending display order in the Reseller Dimension.
  • Show the DAX code for the Year Range
  • Build a measure to provide an answer for the number of resellers (Reseller Count) who fall under the Year Range 1980 1984 ________________________.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!