Forum Discussion

gsksarepta's avatar
gsksarepta
Icon for Helper II rankHelper II
2 years ago
Solved

Help on Missing data fill techniques

Hi, I have table like this in PowerBI I need to fill the missing values in 4th column based on the respective values step3afin column.. for example. Here is the before after table I am hoping to get ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi gsksarepta ,

    Please try to create a new column with below dax formula:

    newresult =
VAR _step3 = [step3afin]
VAR _a =
    CALCULATE (
        MAX ( 'Table'[step4aex] ),
        FILTER ( 'Table', [step3afin] = _step3 )
    )
RETURN
    _a

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • gsksarepta's avatar
    gsksarepta
    Icon for Helper II rankHelper II
    2 years ago

    Hi Amit amitchandak , I didn't understand your response, do you mind adding some more details on what to do ?  Meanwhile, I will go through the links for ideas. Thanks for your time.