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 ,

 

Check

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

 

Best Regards,

Jay