Compare the count of values from last year month to current year month for all month in Matrix

[Anonymous]

Hello,

 new to powe bi, i need to compare last year month count to presene year count, if value increase need to show arrow mark should be up, if decrease arrow should be down in conditional formate

when i use date date add, parallell period, privious month it will compare with in the year of month it won't give result last year month screen shot below

pls help me sort out this issue

[tamerj1]

Hi @Anonymous 

try with two slicers, one for the year and one for the month and avoid using hierarchy slicer 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Use a single slicer and create two measures like below:

current_year_month =
CALCULATE (
    COUNT ( 'table'[value] ),
    FILTER (
        ALLSELECTED ( 'table' ),
        'table'[plant] = SELECTEDVALUE ( 'table'[plant] )
            && YEAR ( 'table'[date] ) = YEAR ( SELECTEDVALUE ( 'table'[date] ) )
            && MONTH ( 'table'[date] ) = MONTH ( SELECTEDVALUE ( 'table'[date] ) )
    )
)

Last_year_month =
CALCULATE (
    COUNT ( 'table'[value] ),
    FILTER (
        ALLSELECTED ( 'table' ),
        'table'[plant] = SELECTEDVALUE ( 'table'[plant] )
            && YEAR ( 'table'[date] )
                = YEAR ( SELECTEDVALUE ( 'table'[date] ) ) - 1
            && MONTH ( 'table'[date] ) = MONTH ( SELECTEDVALUE ( 'table'[date] ) )
    )
)

Best Regards,

Jay