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 

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