Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

YOY BASIC PLEASE

Hi all,   I require your support. it turns out that I have a table in a database where I must compare the difference between years. I do not have a date table because it is not really necessary bec...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous ,

     

    A date table is necessary. You can use some Time Intelligence functions like sameperiodlastyear-function-dax. Then everything will be easy.

     

    currentRev = sum('table'[Rev])
    lastyearRev =
CALCULATE ( SUM ( 'table'[Rev] ), SAMEPERIODLASTYEAR ( 'calendar'[Date] ) )

     

     

    Best Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Anonymous , why don't you creat a new column to transform in date and use acumulated function in this case?

 

Date:= DATE(LEFT("PERIODO";4);MID("PERIODO";5;2);RIGHT("PERIODO";2)