Forum Discussion

rgpsathish's avatar
rgpsathish
Frequent Visitor
4 years ago
Solved

DAX Support

Dear Team,   Is that possible to get the value of last week of Month. like below highlighted image.  
Power BI Dax
  • tamerj1's avatar
    tamerj1
    4 years ago

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

tamerj1's avatar
tamerj1
Community Champion
4 years ago

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?