YOY BASIC PLEASE

[Anonymous]

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

[v-jiascu-msft]

Hi @Anonymous ,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft · Accepted solution]

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]

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)