Forum Discussion

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
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

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