Filling blank cells from same column values

[manisht2388]

Hi team, I want to create a new column with filled blank cells with minimum launching date using the launch_date columns:

[v-yangliu-msft · Accepted solution]

Thanks for the reply from @AntrikshSharma , please allow me to provide another insight: 
Hi  @manisht2388 ,

Here are the steps you can follow：

1. Create calculated column.

New_Launch_Date =
MINX(
    FILTER(ALL('Table'),
    'Table'[Product_Category]=EARLIER('Table'[Product_Category])),[Launch_Date])

2. Result:

Best Regards,

Liu Yang

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

[manisht2388 · Accepted solution]

I created a New Launch Date Column =
IF(ISBLANK('Table'[Launch_Date]),
CALCULATE(MIN('Table'[Launch_Date]),
FILTER(ALLNOBLANKROW('Table'), 'Table'[Product_Category] = EARLIER('Table'[Product_Category] )), 'Table'[Launch_Date]))

This worked for me !! Thanks everyone for your time !!

[v-yangliu-msft · Accepted solution]

Thanks for the reply from @AntrikshSharma , please allow me to provide another insight: 
Hi  @manisht2388 ,

Here are the steps you can follow：

1. Create calculated column.

New_Launch_Date =
MINX(
    FILTER(ALL('Table'),
    'Table'[Product_Category]=EARLIER('Table'[Product_Category])),[Launch_Date])

2. Result:

Best Regards,

Liu Yang

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

[manisht2388]

I rechecked, the date column type is in SHORT DATE format.

[AntrikshSharma]

@manisht2388 

New_Launch_Date = 
CALCULATE ( 
    MIN ( 'Table'[Launch_Date] ),
    'Table'[Launch_Date] <> "",
    ALLEXCEPT ( 'Table', 'Table'[Product_Category] )
)

[manisht2388]

I get this error when added the measure to the table visual

[AntrikshSharma]

you date must be of text data type you need to change them to date data type in Power Query