Result of the last date, not null and >0

[Anonymous]

Hello guys,

How to calculate by DAX the data filtered by the last date that is not null and >0?

On the example below, the result hoped is to replace every blanks, 0's and numbers to 784,10.

[amitchandak]

@Anonymous , Try measure like

lastnonblankvalue(Table[Date], [Valore])

or

calculate(lastnonblankvalue(Table[Date], [Valore]), allexcept(Table, Table[part_number_sem#]))

or

measure = calculate([Valore], filter(Table,Table[Date] = calculate(max(Table[Date]), allexpcept(Table,table[part_number_sem#]))))

[Anonymous]

Not working... I tried to measure like

VAR CurrentName = SELECTEDVALUE(Table[PART_NUMBER_SEM_#])

RETURN

MAXX(

FILTER(ALL(Table),Table[PART_NUMBER_SEM_#]=CurrentName),Table[Valor])

This to result hoped but with Valor = 784,10 because it's the valor of the last date that is not null neither 0.

[amitchandak]

@Anonymous , Try like

Measure =
VAR __id = MAX ('Table'[PART_NUMBER_SEM_#] )
VAR __date = CALCULATE ( MAX('Table'[Date] ), ALLSELECTED ('Table' ), 'Table'[PART_NUMBER_SEM_#] = __id )
CALCULATE ( [Valor] , VALUES ('Table'[PART_NUMBER_SEM_# ),'Table'[PART_NUMBER_SEM_#] = __id,'Table'[Date] = __date )

[Anonymous]

@amitchandak

Firstly I thank you for the disposition to help me with this problem.

However, it didn't work as well...

Obs.: I just renamed the "Measure" to "Val_Com"

[AlB]

Hi @Anonymous 

What is the code for the [Valor] measure?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

I used a divide and average function based on sale.