- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create New Table
Hi all
I would like to create a new table with 2 columns, where:
- column one contains distinct values from a column in another table
- column two is manually filled
Is that possible ? Then, how?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"type" data where? Powerbi is not a place where you enter data, it's not excel.
You should prepare data in advance.
It's better if you explain your requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, if you have to manually add data this won't be automatically. You can do several things:
1- Create a table visualization with the first column and export that data. Then open de csv file, make it a table and add the second column.
2- Create a new dax table like DISTINCT(Table[Column1]) or ALL(Table[Column1]). Go to view data right click and copy table to an excel file where you can continue with the second column.
3- Similar to the number 2, you may be able to paste the copy of the data in "Enter Data" option on power bi to add directly to power bi instead of going through excel.
Regards,
Happy to help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ibarrau thank you
That will make the process static, whereas I need it to be dynamic.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Define "manually filled"?
You can use a combination of ADDCOLUMNS, SELECTCOLUMNS and DISTINCT
something like
ADDCOLUMNS(SELECTCOLUMNS(DISTINCT(yourtable[yourcolumn])); "new column"; new values)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous thank you,
you're right on asking more details on "manually filled". I need to be able to type values in the 2nd column.
So 1 column is the result of a DAX formula, the 2nd column is where I type data. Is that possible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"type" data where? Powerbi is not a place where you enter data, it's not excel.
You should prepare data in advance.
It's better if you explain your requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
well, I tried to do something that, one day, will become available 😁
Meantime, I will have to either manage the situation on each SQL server (preferred as it is dynamic) or use an Excel sheet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think it will become available as PBI is an analytical solution, so you don't typically enter data in these tools. What you can do is to enter "parameters" (using the function available in PBI) which can be used for what-if scenarios.
But again: what is your requirement? If you HAVE TO *enter* data make reports, you're not "thinking it" correctly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous thank you for your help.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-17-2024 08:56 PM | |||
06-03-2024 07:29 PM | |||
04-23-2024 12:24 AM | |||
06-27-2024 04:44 AM | |||
06-17-2024 11:27 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |