Forum Discussion

GGN's avatar
GGN
New Member
4 years ago
Solved

Week on week percetnage

Hey all, I'm nre here and have a question:

 

How can I get a week-on-week percentage change from this data?

 

 It only comes from one table where I have a CreatedDate, and count the events.

 

Any input is much appreciated!

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

    Hi GGN ,

    According to your description, I create a sample.

    Here's my solution.

    Calls% = 
VAR LW =
    MAXX (
        FILTER (
            ALL ( 'Call Reporting' ),
            'Call Reporting'[Year] = MAX ( 'Call Reporting'[Year] )
                && 'Call Reporting'[Week Number]
                    = MAX ( 'Call Reporting'[Week Number] ) - 1
        ),
        'Call Reporting'[nbavs_From_Number_c]
    )
RETURN
    DIVIDE ( MAX ( 'Call Reporting'[nbavs_From_Number_c] ) - LW, LW, 0 )

    Get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

     

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

     

4 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    var LW =
    CALCULATE ( SUM (Table[value] ), FILTER ( ALL ( 'Calendar' ), 'Calendar'[WeekNum] = MIN ( 'Calendar'[WeekNum] ) - 1 ) ) RETURN

    DIVIDE ( SUM ( Table[Value] ) - LW, LW 0 )



    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

  • GGN's avatar
    GGN
    New Member
    4 years ago

    Thanks for the reply. I had to modify it to suit my tables, as I don't have a separate calendar.

     

    The data it's returning dones't make any sense I don't think.

     

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi GGN ,

    According to your description, I create a sample.

    Here's my solution.

    Calls% = 
VAR LW =
    MAXX (
        FILTER (
            ALL ( 'Call Reporting' ),
            'Call Reporting'[Year] = MAX ( 'Call Reporting'[Year] )
                && 'Call Reporting'[Week Number]
                    = MAX ( 'Call Reporting'[Week Number] ) - 1
        ),
        'Call Reporting'[nbavs_From_Number_c]
    )
RETURN
    DIVIDE ( MAX ( 'Call Reporting'[nbavs_From_Number_c] ) - LW, LW, 0 )

    Get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

     

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

     

    • GGN's avatar
      GGN
      New Member
      4 years ago

      Hi, thank you for the message! I did end up with something similar, and the initial issues turned out to be the imprted data.

       

      Much appreciated!