Forum Discussion

nhutruong's avatar
nhutruong
Frequent Visitor
1 year ago
Solved

Autofill null value based on one column data - using dax calculated column

Dear all,   Currently my data base looks like the picture below. with many empty row, each items have a serial no. attached. I want value to look like the desired output column.   I have searche...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    This calculated column formula works

    Column = LOOKUPVALUE(Data[Data current],Data[Serial],CALCULATE(MIN(Data[Serial]),FILTER(Data,Data[ITEM]=EARLIER(Data[ITEM])&&Data[Serial]>=EARLIER(Data[Serial])&&Data[Data current]<>BLANK())),Data[ITEM],Data[ITEM])

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

This calculated column formula works

Column = LOOKUPVALUE(Data[Data current],Data[Serial],CALCULATE(MIN(Data[Serial]),FILTER(Data,Data[ITEM]=EARLIER(Data[ITEM])&&Data[Serial]>=EARLIER(Data[Serial])&&Data[Data current]<>BLANK())),Data[ITEM],Data[ITEM])

Hope this helps.