Forum Discussion

RMV's avatar
RMV
Helper V
9 years ago
Solved

define specific values for new table

Hi all,   Can i define specific values to be shown for a new table?   Regards
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi RMV,

     

    If I understand you correctly, you should be able to use DATATABLE function(DAX) to create the table with your defined value in this scenario.

     

    For more details your refer to this article. And the formula below is for your reference. :smileyhappy:

    New Table = 
DATATABLE (
    "Name", STRING,
    "Region", STRING,
    {
        { " User1", "East" },
        { " User2", "East" },
        { " User3", "West" },
        { " User4", "West" },
        { " User4", "East" }
    }
)

     

    Regards

RMV's avatar
RMV
Helper V
9 years ago

Hi v-ljerr-msft,

 

I mean create new table using DAX.

And I'd like to define the values of the new table.

 

For example

ColumnName

01-1

02-2

etc

 

This "01-1", "02-2" etc is defined directly using the DAX with the New Table feature.

Is this possible? Kindly advise. 

 

Regards,

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi RMV,

 

If I understand you correctly, you should be able to use DATATABLE function(DAX) to create the table with your defined value in this scenario.

 

For more details your refer to this article. And the formula below is for your reference. :smileyhappy:

New Table = 
DATATABLE (
    "Name", STRING,
    "Region", STRING,
    {
        { " User1", "East" },
        { " User2", "East" },
        { " User3", "West" },
        { " User4", "West" },
        { " User4", "East" }
    }
)

 

Regards

  • RMV's avatar
    RMV
    Helper V
    9 years ago

    Thanks, v-ljerr-msft!

    This is what I'm looking for.

    It works well.