Transform a calculated field into a measure and keep the same result.

[railtons]

Hello team, I'm here again to ask for help, now with the use of measures.
This is a subject I'm still very basic on.
I have a requirement to make simulations based on current project information.
In this image below I have "Reste a faire" as the time left to finish the project. I was able to make this projection based on capacity but with the use of a column in the table. I know that to use the What-if function in power BI, operations must be done based on measures. So here comes my question....
How do I get the same result I have from the ''Estimated remaining work'' column, but instead of a column, it's a measure.
Then I would change the information in the simulation section and the result would be applied.

Here's my column that stores the simulation:

In the following image, I show that I change my remaining work (increase by 10), the measure increases correctly, but the information in my simulation doesn't change (I know it doesn't change because it's a field in the table and not a measure). And exactly what I need is how to turn my calculated field into a measure, but one that works exactly the same way? Just so I can use the What-if function.

Thanks a lot.

[Anonymous · Accepted solution]

Hi @railtons ,

If I understand you correctly, you want your Estimated remaining work column to add this value as a whole when an input value exists for your What-if parameter. You can leave your column as is and add an additional measure:

New = MAX('Table'[Estimated remaining work]) + 'Parameter'[Parameter Value]

For example, here I have a calculated column [NETWORKDAYS], and I create a What-if parameter. I create a measure by using this DAX:

Measure = MAX('Table'[NETWORKDATS]) + 'Parameter'[Parameter Value]

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

[railtons]

It works, Thanks 🙂

[railtons]

Just to add more information:
this question is the result of the help received through this post. : Solved: Re: Questions about creating a column with project... - Microsoft Fabric Community