adding a manual column to a calculated table

[dedelman_clng]

Is there a way to manually enter data on a calculated table?  I have calculated a table based DISTINCT PersonID values from a list of trouble tickets, and brought in the PersonName column through the RELATED function. I would like to add column PersonOrganization to the table, but that data doesn't exist in any loaded data, so I would need to add and maintain manually.

Is what I'm doing even possible, or should I maintain this info in Excel and bring the Excel into the dataset?

Thanks,

David

[Dasbas · Accepted solution]

@dedelman_clng Hi,

To my knowledge this is not possible. It is also not very convenient to maintain data in powerBI. Probably your best option is, as you mentioned, keep the info in an Excel file and import that file. That way you can keep the excel up to date and just press update in powerBI.

Kind Regards,

Max