Forum Discussion

rgpsathish's avatar
rgpsathish
Frequent Visitor
3 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
    3 years ago

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

4 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 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?

  • rgpsathish's avatar
    rgpsathish
    Frequent Visitor
    3 years ago

    Hi tamerj1 
    this is the display i want

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

     



     

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

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