Filling blank cells from same column values

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

Anonymous
Not applicable
2 years ago
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 !!
AntrikshSharma
Community Champion
2 years ago
Anonymous

New_Launch_Date = CALCULATE ( MIN ( 'Table'[Launch_Date] ), 'Table'[Launch_Date] <> "", ALLEXCEPT ( 'Table', 'Table'[Product_Category] ) )
- Anonymous
  Not applicable
  2 years ago
  I get this error when added the measure to the table visual
  - AntrikshSharma
    Community Champion
    2 years ago
    you date must be of text data type you need to change them to date data type in Power Query
Anonymous
Not applicable
2 years ago
Thanks for the reply from AntrikshSharma , please allow me to provide another insight:
Hi Anonymous ,

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
Filling blank cells from same column values.pbix49 KB
Anonymous
Not applicable
2 years ago
I rechecked, the date column type is in SHORT DATE format.

Forum Discussion