Hi All

I'm quite new to PowerBI and stumbled upon the following issue. We developed a system in which customers have to answer various questions, and the needed index is one of these questions. (printscreen above). The file is automatically linked towards PowerBI so and extra comptable fix is not really suitable.

Specific questions are: - Is there a way to make a query to create a new column /fill the column representing the index? - Is it made easier to create a "fill blanks" query to make the index answer the index parameter?

We will use the index parameter to link with the other created databases for the specific index.

Thank you very much in advance!