DAX expression to fill the blank values with previous value

[kkalyanrr]

Hello,

I've a datamodel simmilar to the below ones, and looking for a DAX expression to get the required result.

Thanks

 

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula works

=LOOKUPVALUE(Data[Stage],Data[ContractID],Data[ContractID],Data[CreateDate],CALCULATE(MIN(Data[CreateDate]),FILTER(Data,Data[ContractID]=EARLIER(Data[ContractID]))))

Hope this helps.

[Anonymous]

Hi kkalyanrr,

If you can access the query editor, select the column you want to fill and select "Fill Down" in the "Transform" tab of the ribbon.

Cheers

[kkalyanrr]

Sorry @Anonymous  , I am looking for a DAX expression, cause these all are calculated columns.