Help with lastnonblank or similar

[birnabjorns]

 

[birnabjorns]

ooobs, My first question gone bad. Can´t seem to figure out how to edit the first post, so I just put the question here. Sorry about that.

Anyways. I am trying to make a calculated column where the blanks are filled with last known value. I have tried the lastnonblank without luck so far. Can anybody help me out?
Thanks in advance,
Birna

 

[sandy666]

any logical description?

 

[sandy666]

use Power Query, change data type of the last column to text then Fill Down and then change to decimals

btw. use xl2bb to post example data not a picture

 

[birnabjorns]

any logical description?

Hi Sandy. Sorry about that, my question is in the next comment below;

ooobs, My first question gone bad. Can´t seem to figure out how to edit the first post, so I just put the question here. Sorry about that.

Anyways. I am trying to make a calculated column where the blanks are filled with last known value. I have tried the lastnonblank without luck so far. Can anybody help me out?
Thanks in advance,
Birna

 

[sandy666]

see post#4

 

[birnabjorns]

use Power Query, change data type of the last column to text then Fill Down and then change to decimals

btw. use xl2bb to post example data not a picture

Thanks for the tip regarding xl2bb. Will do that in the future.
I will look into the Power Query suggestion.
I am using power pivot and am more familiar with that. Any suggestions that can be used directly in power pivot?

 

[sandy666]

I'd suggest to use Power Query to transform data as you need then load to DataModel directly and use Power Pivot
sorry but Power Pivot is useless to me in most cases

but if you really need DAX try this

Re: Dax, fill down in formula

Hi Try Using this calculated column New Value = VAR LastNonBlankDate = CALCULATE ( LASTNONBLANK ( TableName[Date], 1 ), FILTER ( ALL ( TableName ), TableName[Date] <= EARLIER ( TableName[Date] ) &&& NOT ( ISBLANK ( TableName[Value]...

community.powerbi.com