cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

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

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
Frequent Visitor

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

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

Hi @judato88 ,