Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Max value per week based on WEEK relationship between tables

Hi All,

I want a measure for MAX value per week and further use this measure in a table which does not have a direct active relationship.
Although, week relatiponship exist based on week number.

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Check

    Column = CALCULATE(MAX('Table'[value]),FILTER('Table','Table'[weeknum]='Table (2)'[weeknum]&&'Table'[product]='Table (2)'[product]))

     

    Best Regards,

    Jay 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

     

    I would use

    calculate(max([value], allexcept(table,table[week_num]))

     

    Did I resolve your issue? Mark my post as a solution!

     

    Appreciate your Kudos, Press the thumbs up button!!

     

    Regards,
    Pranit

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , take week (unsummarized), and these two measure

    for product take -lastnonblankvalue(table[value],max(table[product]))

    for value take max(Table[Value])

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Check

    Column = CALCULATE(MAX('Table'[value]),FILTER('Table','Table'[weeknum]='Table (2)'[weeknum]&&'Table'[product]='Table (2)'[product]))

     

    Best Regards,

    Jay