Forum Discussion
Anonymous
2 years agoNot applicable
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:
- Anonymous2 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
- Anonymous2 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 !!
Anonymous
2 years agoNot applicable
I get this error when added the measure to the table visual
AntrikshSharma
2 years agoCommunity Champion
you date must be of text data type you need to change them to date data type in Power Query