relative measure in graphs in cascade % from previous

[cosminc]

Hi all

i have 2 graphs - monthly and weekdays split and i need to build same graphs but with evolutiuon than previous (%relatives)

for ex: feb 2017: 23.4/24.7*100-100

mar 2017:20.7/23.4*100-100

same for 2018 on right

and for weekday also in the other graph (Tuesday 16.7/16.3*100-100) and so on

Can youy help me please with that measures? let's say that the dimensions are Year, Months and Sales for firts graph and Weekday and sales for the second

Thanks!

Cosmin

[v-yulgu-msft · Accepted solution]

Hi @cosminc,

Based on below sample data, you could create measures like below:

Previous month sales =
CALCULATE (
    SUM ( 'Monthly Sales'[Sales] ),
    FILTER (
        ALL ( 'Monthly Sales' ),
        'Monthly Sales'[Year] = MAX ( 'Monthly Sales'[Year] )
            && 'Monthly Sales'[Month]
                = MAX ( 'Monthly Sales'[Month] ) - 1
    )
)

%relatives =
IF (
    [Previous month sales] <> BLANK (),
    MAX ( 'Monthly Sales'[Sales] ) / [Previous month sales]
        * 100
        - 100,
    BLANK ()
)

Best regards,

Yuliana Gu

[cosminc]

Hi

Thanks a lot, very helpfull your support.

thanks again also for your effort, i was stuck on this!

Cosmin