Forum Discussion
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
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,
3 Replies
v-jiascu-msftMicrosoft Employee
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,
- v-jiascu-msft
Hi Anonymous ,
Could you please mark the proper answers as solutions?
Best Regards,