Forum Discussion

NDDD's avatar
NDDD
Icon for Helper I rankHelper I
4 years ago

Total by latest date

Good day, 

 

  I need help how to get the latest date values in table. 

 

Thank you 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  NDDD ,

    I created some data:

    Here are the steps you can follow：

    1. Create calculated column.

    LastDate =
MAXX(FILTER(ALL('Table'),'Table'[sales orders numbers]=EARLIER('Table'[sales orders numbers])),[Date])

    2. Result:

    If you need pbix, please click here.

    Total by latest date.pbix

     

    Best Regards,

    Liu Yang

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

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi 

    You can use below Dax to ge the latest date.

    LatestDate = CALCULATE(MAX(Sales[Order Date]))

    Appreciate a Kudos! ‌‌
    If this helps and resolves the issue, please mark it as a Solution! ‌‌

    Regards,
    N V Durga Prasad

     
  • NDDD's avatar
    NDDD
    Icon for Helper I rankHelper I
    4 years ago

    nvprasad thanks! I didn't mentioned we have different sales orders numbers where I need the latest date for each order.

    Thank you