Forum Discussion

andreaturri27's avatar
andreaturri27
Icon for Helper I rankHelper I
4 years ago
Solved

Increase Order and Price

Good Morning,   sorry for my english.    How calculate increase / Decrease item and  % increse  in this table?   Thank you   
Need Help
Tutorial Requests
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, andreaturri27 

     

    According to your description, you can create two measures.

    Like this:

    Measure1 = 
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [ExpectedDeliveryDate] < SELECTEDVALUE ( 'Table'[ExpectedDeliveryDate] )
        ),
        [ExpectedDeliveryDate]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( 'Table' ), [ExpectedDeliveryDate] = a ),
        [Prezzo acquisto]
    )
RETURN
    MAX( 'Table'[Prezzo acquisto] ) - b

    Measure2 = 
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [ExpectedDeliveryDate] < SELECTEDVALUE ( 'Table'[ExpectedDeliveryDate] )
        ),
        [ExpectedDeliveryDate]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( 'Table' ), [ExpectedDeliveryDate] = a ),
        [Prezzo acquisto]
    )
RETURN
    DIVIDE (
        MAX ( 'Table'[Prezzo acquisto] ) - b,
        MAX ( 'Table'[Prezzo acquisto] )
    )

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.


    Best Regards,

    Community Support Team _ Janey

  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, andreaturri27 

     

    You need to modify the code according to your needs.

    Like :

    Measure1 = 
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [ExpectedDeliveryDate] < SELECTEDVALUE ( 'Table'[ExpectedDeliveryDate] )&&
            [item] < SELECTEDVALUE ( 'Table'[item] )
        ),
        [ExpectedDeliveryDate]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( 'Table' ), [ExpectedDeliveryDate] = a && 
        [item] < SELECTEDVALUE ( 'Table'[item] )),
        [Prezzo acquisto]
    )
RETURN
    MAX( 'Table'[Prezzo acquisto] ) - b

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.


    Best Regards,

    Community Support Team _ Janey

     

goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
4 years ago

Hello there andreaturri27 ! You can try the following for the variation:

Variation =
VAR _current =
    SUM ( Table[Prezzo acquisto] )
VAR _previous =
    CALCULATE (
        _current,
        FILTER (
            ALL ( Table[Numero Ordine] ),
            Table[Numero Ordine]
                = ( SELECTEDVALUE ( Table[Numero Ordine] ) - 1 )
        )
    )
RETURN
    _current - _previous

 And for the percentage change:

 

% Variation =
VAR _current =
    SUM ( Table[Prezzo acquisto] )
VAR _previous =
    CALCULATE (
        _current,
        FILTER (
            ALL ( Table[Numero Ordine] ),
            Table[Numero Ordine]
                = ( SELECTEDVALUE ( Table[Numero Ordine] ) - 1 )
        )
    )
RETURN
    DIVIDE ( _current - _previous, _previous, 0 )

And format it as a % field.

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes