Forum Discussion

Grevatious's avatar
Grevatious
Frequent Visitor
6 years ago
Solved

Get the last delivery date

Hello everyone,   I need some help! I have two tables. The first one has all of the order description and client information and the other shows all the information regarding the delivery of each o...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Grevatious ,

     

    Would you please refer to the following measure:

    last delivery date =

CALCULATE (

    MAX ( 'Delivery Information'[Delivery Date] ),

    ALL ( 'Delivery Information' ),

    'Delivery Information'[Order] IN DISTINCT ( Orders[Order] )

)

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

     

    Best Regards,

    Dedmon Dai

PowerBIIE's avatar
PowerBIIE
Frequent Visitor
4 years ago

Hey - I want to use something like this for a calculated column. If I use this measure, it does not work correctly, how would I work around it?