topic Re: DAX Support in DAX Commands and Tips

DAX Support

rgpsathish — Mon, 05 Sep 2022 09:56:41 GMT

Dear Team,

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

Re: DAX Support

tamerj1 — Mon, 05 Sep 2022 10:15:31 GMT

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?

Re: DAX Support

rgpsathish — Mon, 05 Sep 2022 10:37:25 GMT

Hi tamerj1
this is the display i want

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

Re: DAX Support

tamerj1 — Mon, 05 Sep 2022 11:27:49 GMT

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

Re: DAX Support

rgpsathish — Mon, 05 Sep 2022 11:46:23 GMT

Hi tamerj1

Issue is solved.
Thanks alot for your quick support😊