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

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

Hi RMV,

 

Do you mean create a new table using DAX/M, or add a Table visual on the report with some specific defined values?

 

Could post some sample data with your expected result? :smileyhappy: 

 

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.