Goal:
Create a new column, named test , containing numbers in SSAS only inside of DSV design view.
If StatePrinceCode's column has value NSW it shall have value 1 etc.
StateProvinceCode test
------------------------------
NSW 1
QLD 2
SA 3
Problem:
How should I enable to do it? I tried using IIF and case statement but it doesn't want to do it due to text value. It only works with numbers only.
Information:
- I strongly believe that you need to create a named calculation as a extra column to add the value
The new column shall apply in the table Geography in SSAS.
In this context no usage of SQL server database