Week on week percetnage

[GGN]

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 · Accepted solution]

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]

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!

[GGN]

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.

[ValtteriN]

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/