How can I show trends in a table based on previous Number not only Week over week but without Date?

[floxxy]

Is there a way to schow kind of Week on Week trend without having a Date as basis? 

So here is the simple example table:

Steps	Revenue
Step1	125
Step2	123
Step3	155
Step4	184
Step2	112
Step3	123
Step1	142
Step4	110
Step2	129

And the result should look like this: 

	Sum of Revenue	Trend vs. Previous
Step1	267
Step2	364	36%
Step3	278	-24%
Step4	294	6%

[Zubair_Muhammad · Accepted solution]

@floxxy

Try this MEASURE

Trend Vs Previous =
VAR PreviousStep =
    CALCULATE (
        MAX ( TableName[Steps] ),
        FILTER (
            ALLSELECTED ( TableName[Steps] ),
            TableName[Steps] < SELECTEDVALUE ( TableName[Steps] )
        )
    )
VAR RevenuePreviousStep =
    CALCULATE ( SUM ( TableName[Revenue] ), TableName[Steps] = PreviousStep )
RETURN
    IF (
        NOT ( ISBLANK ( PreviousStep ) ),
        SUM ( TableName[Revenue] ) / RevenuePreviousStep
            - 1
    )

[Zubair_Muhammad]

@floxxy