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

4 Replies

  • 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