Add new column with next non blank value

Question

Hi everyone,&nbsp;&nbsp;I have this table:&nbsp;I want to add a new column filling the blank values with the next value for each SKU (A, B and C) and the next date. I tried this DAX formula:&nbsp;FIRSTNONBLANK = IF(ISBLANK('Table'[Stock]) || 'Table'[Stock] = "",CALCULATE(FIRSTNONBLANK('Table'[Stock], TRUE()),FILTER('Table','Table'[SKU] = EARLIER('Table'[SKU]) &amp;&amp; 'Table'[Date] &lt;= EARLIER('Table'[Date]) &amp;&amp; 'Table'[Stock] &lt;&gt; "")),[Stock])&nbsp;These are the expected values for each SKU (A, B and C) and the FIRSTNONBLANK errors I put in red. All the values for B and C are zero. Where is my mistake?&nbsp;😥&nbsp;&nbsp;

freemanz · Accepted Answer

hi Andregewehr&nbsp;try like:Column =&nbsp; &nbsp; MAXX(&nbsp; &nbsp; &nbsp; &nbsp; TOPN(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Table',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Table'[SKU] = EARLIER('Table'[SKU]) &amp;&amp; 'Table'[Date] &lt;= EARLIER('Table'[Date]) &amp;&amp; 'Table'[Stock] &lt;&gt;BLANK()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Table'[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Table'[Stock]&nbsp;&nbsp;&nbsp;&nbsp;)

Forum Discussion

Add new column with next non blank value

2 Replies

Related content

Blank columns when doing Measure Name Measure Value approach

Replace Values Null to Blank or Blank to Null

Remove Blank Columns

Splitting Column values

Return value of a column if another column is null/blank?