Is it possible to create a mathematical algorithm using Power BI?

[medicina_khv1]

Hello,

1. First row. Reference values ​​(min max)

2. Third row. Intermediate results.

3. Fifth row and below. Values ​​to 100. You can change 100 from 1 to 1000, for example: if you change it to 1, then all the values ​​in the columns of this row must be reduced by 100 times, if 100, then multiply by 10.

Problem statement: You need to find a row in the table in which the addition of the values ​​in the columns of this row with the corresponding values ​​of the columns in the intermediate results are in the reference range of the first line.

Neurologist.xlsx

If it is impossible to create such an algorithm using Power BI, then on which forum can I ask?

Best regards,
Evgeny

[v-sathmakuri]

Hi @medicina_khv1 ,

I hope this information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @medicina_khv1 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!

[v-sathmakuri]

Hi @medicina_khv1 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin  for the prompt response.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[lbendlin]

Where are the column names?  What does "intermediate"  mean in this context?  What is the desired algorithm?

[medicina_khv1]

Thank you!
1. "intermediate" means that each user will have their own values
2. "desired algorithm" selection of a row (changed from 1 to 1000) the sum of the columns with "intermediate" was in the reference values ​​of 1 row of the table, or most closely matched the specified criteria.

[lbendlin]

Here is one method to compute proximity

https://www.red-gate.com/simple-talk/business-intelligence/data-science/comparing-groups-for-similar...