Create a static table in a tabular model


I have a static dimension to create in SSAS tabular model and without creating it in the datawarehouse which is populating the cube, the dimension is like below :

Status                StatusID
In                    1
Out                   2
In (Exit Confirmed)   3

How can achieve that ?

>Solution :

You can easily use SELECTCOLUMNS() function in DAX to achieve this :

             {("In", 1)
             , ("Out", 2)
             , ("In (Exit Confirmed)", 3)}
             , "Status", [Value1]
             , "StatusID", [Value2]

Leave a Reply Cancel reply