topic Re: Filling blank cells from same column values in DAX Commands and Tips

Filling blank cells from same column values

Anonymous — Wed, 24 Jul 2024 15:06:18 GMT

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

Re: Filling blank cells from same column values

AntrikshSharma — Wed, 24 Jul 2024 15:16:10 GMT

@Anonymous

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

Re: Filling blank cells from same column values

Anonymous — Wed, 24 Jul 2024 15:27:23 GMT

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

Re: Filling blank cells from same column values

AntrikshSharma — Wed, 24 Jul 2024 17:11:27 GMT

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

Re: Filling blank cells from same column values

Anonymous — Thu, 25 Jul 2024 17:01:30 GMT

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

Re: Filling blank cells from same column values

Anonymous — Fri, 26 Jul 2024 00:33:45 GMT

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

Re: Filling blank cells from same column values

Anonymous — Fri, 09 Aug 2024 09:10:05 GMT

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 !!