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 Samarth,

     

    Does this allow to fill based on name of project? since in my above example the probability adjusted is different for each project.

      • 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"})