Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |