Forum Discussion

gsksarepta's avatar
gsksarepta
Helper 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.

Anonymous's avatar
Anonymous
Not applicable
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
Helper II
2 years ago

Thanks for this, appreciate it.