cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
judato88 Frequent Visitor
Frequent Visitor

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 because it is only a single table, therefore I must compare the growth between a specific period, it is like making a formula of YOY. my table is something like this:

 

Periodo         Rev

20190113 $   5,000
20190213 $   4,000
20190302 $   2,000
20190201 $       698
20180113 $   3,550
20180213 $   4,580
20180302 $       480
20180201 $   3,980

 

Therefore I would need to compare 20190101 vs 20180101 and so with others, 20190201 vs 20180201

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: YOY BASIC PLEASE

Hi @judato88 ,

 

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
rfortunato Frequent Visitor
Frequent Visitor

Re: YOY BASIC PLEASE

Hello @judato88 , 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)
Community Support Team
Community Support Team

Re: YOY BASIC PLEASE

Hi @judato88 ,

 

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: YOY BASIC PLEASE

Hi @judato88 ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.