Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Summarizing table sales

I have order table like    CustomerId OrderAmount Orderdatetime OrderAmountCurrency AAA 120 02/03/2022 02:03 US$120 AAA 20 02/03/2022 02:20 US$20 AAA 320 03/03/2022 03:03 US...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You can do this in a table visual like this:

     

    The InitialOrder and FinalOrder measures are defined like this:

    FinalOrder = 
VAR OrderDate = MAX ('Table'[Orderdatetime] ) /*Use MIN instead for InitialOrder*/
RETURN
    CALCULATE (
        SELECTEDVALUE ('Table'[OrderAmountCurrency] ),
        'Table'[Orderdatetime] = OrderDate
    )
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

You can do this in a table visual like this:

 

The InitialOrder and FinalOrder measures are defined like this:

FinalOrder = 
VAR OrderDate = MAX ('Table'[Orderdatetime] ) /*Use MIN instead for InitialOrder*/
RETURN
    CALCULATE (
        SELECTEDVALUE ('Table'[OrderAmountCurrency] ),
        'Table'[Orderdatetime] = OrderDate
    )