Manual input in a DAX generated table

[Kanivan]

I have generated a new table using the DAX function DISTINCT. I now want to add manual input in a new column in this table so that I can use this for mapping purposes. Because its a DAX generated table I cant use the query editor. Is there a way to add manual data in a DAX generated table or a workaround?

[v-xuding-msft]

Hi @Kanivan ,

It’s not supported for adding manual input in a calculated table directly.  If the value you want to add is logical for the existing table, maybe you could solve it using functions, like IF, SWITCH, CROSSJOIN. You can post some sample data that we can help you quickly. If not, I’m afraid you need to solve it in Excel firstly, then import the file into Power BI.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kanivan]

thanks for the reply Xue Ding. I have 'solved' the issue by using 2 tables. One which contains the unique values and a second one which is a copy of this table where I enrich the second column manually. I then do a lookup of the value in the inital table to the second table to check whether all the fields are filled in. This is so that I can check if a new unique value is added in the future.