topic Compare the count of values from last year month to current year month for all month in Matrix in DAX Commands and Tips

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

Anonymous — Thu, 30 Jun 2022 07:27:26 GMT

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

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

tamerj1 — Thu, 30 Jun 2022 08:48:04 GMT

Hi Anonymous

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

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

Anonymous — Wed, 06 Jul 2022 08:27:27 GMT

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