define specific values for new table

[RMV]

Hi all,

Can i define specific values to be shown for a new table?

Regards

[v-ljerr-msft]

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?  

Regards

[RMV]

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 · Accepted solution]

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. 

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

Regards

[RMV]

Thanks, @v-ljerr-msft!

This is what I'm looking for.

It works well.