DAX: Return the previous nonblankvalue

Hi Community, I am working on a sales table (1), when the sales value is null I have to return the previous nonblankvalue for each product (2). I used the following formula but it's not returning t...

DAX

DAX Query

Desktop

Anonymous

7 years ago

[Column] =
var __product = Products[Product]
var __date = __Products[DateKey]
var __lookupTable =
	filter(
		filter(
			Products,
			Products[Product] = __product
		),
		NOT ISBLANK( Products[Sales] )
		&& Products[DateKey] <= __date 
	)
var __sales =
	MAXX(
		TOPN(
			1,
			__lookupTable,
			Products[DateKey]
		),
		Products[Sales]
	)
return
	__sales

Best

Darek

Anonymous

Not applicable

7 years ago

[Column] =
var __product = Products[Product]
var __date = __Products[DateKey]
var __lookupTable =
	filter(
		filter(
			Products,
			Products[Product] = __product
		),
		NOT ISBLANK( Products[Sales] )
		&& Products[DateKey] <= __date 
	)
var __sales =
	MAXX(
		TOPN(
			1,
			__lookupTable,
			Products[DateKey]
		),
		Products[Sales]
	)
return
	__sales

Best

Darek

DataVitalizer
Super User
7 years ago
Hi Anonymous ,
Thank you for the solution. It works :)

Forum Discussion

DAX: Return the previous nonblankvalue