Forum Discussion

laura_ESNH's avatar
laura_ESNH
Frequent Visitor
6 years ago
Solved

New column with data from latest entry

I am working on a project for a weight loss program. We track the participants weight and BMI each month. I have created a table with the maximum weight, minimum weight and quick measures of t...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi laura_ESNH ,

     

    try this.

     

     

    Last Weight = CALCULATE(MAX('Table'[Weight]), FILTER(ALL('Table'[Reporting Date].[Date]), 'Table'[Reporting Date].[Date] = MAX('Table'[Reporting Date])))

     

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago
Try to remove the last ". [Date]" between the MAX brackets.
(Look at my code sample)
laura_ESNH's avatar
laura_ESNH
Frequent Visitor
6 years ago

Hi mwegener - That worked! Sorry that I missed that nuance from your initial solution. I marked that post as the solution. Thanks for the help!