DAX Support

[rgpsathish]

Dear Team,

Is that possible to get the value of last week of Month. like below highlighted image.

[rgpsathish]

Hi @tamerj1 
this is the display i want

From This data. ( Currently i applied Average of value so that data not showing correctly )

[tamerj1 · Accepted solution]

HI @rgpsathish 
You can try a new measure 
Measure = MAXX ( TOPN ( 1, Data, Data[Y_W] ), Data[Value] )

[rgpsathish]

Hi @tamerj1 

Issue is solved.
Thanks alot for your quick support😊

[tamerj1]

Hi @rgpsathish 
As a new column or measure? And what exactly would you like the column or the measure display? Do you have week number column? If yes is it the year week number or the month week number or is it a date format column?