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....
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.

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

Hi, i tried to replicate what you have created in the file but have a problem.

 

the probability adjusted seems to fill down from another source

the picture below should show a probability adjusted for  90 like it does at the bottom of the image (the 90 is source data). however for ALL projects in my file the probability adjusted is 25. 

 

the forumla i use:

= Table.FillDown(#"Changed Type",{"Prob_adj"})

 

 

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
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.