Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Latest Month Measure

Hi, i want to create a measure show the sum of invoices from the latest month, my data set is several months out of date so i need to look for the latest month of data in the data set, fairly confident i need to use the MAX function but can't quite work out how to include it in the measure, thank you!

 

Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi Anonymous ,

    try this measure, maybe it works, but if you can share some sample data of your table it is better.

     

    CALCULATE(

                     SUM('Table'[Amount]),

                     'Table'[Month] = MAX('Table'[Month])

    )

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Anonymous ,

    try this measure, maybe it works, but if you can share some sample data of your table it is better.

     

    CALCULATE(

                     SUM('Table'[Amount]),

                     'Table'[Month] = MAX('Table'[Month])

    )

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.