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
Most Valuable Professional
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.

  • laura_ESNH's avatar
    laura_ESNH
    Frequent Visitor
    6 years ago

    I entered exactly what you sent, replacing 'Table' with my table name. I didn't get any results in the column. 

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi laura_ESNH ,

       

      did you use a date table?

      Did you create it as a measure?

      Could you share a sample PBIX file?

       

       

      • laura_ESNH's avatar
        laura_ESNH
        Frequent Visitor
        6 years ago

        Hi mwegener - I appreciate you sticking with me. To answer your questions...

         

        I used the date field as it imports into PowerBI. After import, 

        Yes, I created a measure.

        Unfortunately, the organization I work for is very restrictive on sharing documents through OneDrive.

        I've attached some additional screen captures. Let me know if you want to see something else.

        Visual I'm trying to finish:

        Visual

        Data

        Data

        Measure

        Measure  

         

        Thank you so much for your help!!