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
Get step-by-step solutions from verified subject matter experts
