Forum Discussion

jonbox's avatar
jonbox
Icon for Helper II rankHelper II
4 years ago
Solved

Fill in blanks based on existing data

I'm trying to fill in some blanks on the below "Probability Adjusted" column.

You can see for each project, "system upgrade", "refresh" and "building work" there are gaps under probability adjusted.

 

Essentially what i want is a measure that assigns the probability adusted based on the project name, e.g. where there are missing gaps under probability adjusted, i want those to be filled in with the probability adjusted of that project.

 

So row 3 should have probability adjusted 90%, row 6 100%, row 9 50%.

 

I'm not sure on the logic though.

Any help please?

 

 

Project NameTypePredicted SpendActual SpendProbability Adjusted
System UpgradeComplete Spend10010090%
System UpgradePredicted Spend10010090%
System UpgradeCurrent Spend200200 
RefreshComplete Spend300300100%
RefreshPredicted Spend200200100%
RefreshCurrent Spend100100 
Building WorkComplete Spend20020050%
Building WorkPredicted Spend20020050%
Building WorkCurrent Spend400400 
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi jonbox 

    Here are 2 ways for your reference,

    (1) If you want to create a measure

    Measure = 
var _value= CALCULATE(MAX('Table'[Probability Adjusted]),FILTER(ALL('Table'),'Table'[Project Name]= MIN('Table'[Project Name]) && NOT(ISBLANK('Table'[Probability Adjusted]))))
return IF(ISBLANK( MIN('Table'[Probability Adjusted])),_value, MIN('Table'[Probability Adjusted]))

    (2) Power Query Editor - Transform - Fill - Down,

    Best Regards,

    Community Support Team _Tang

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

5 Replies