%YoY doesn't work

[Anonymous]

I am new to Power BI and encountered a problem that:

It works fine in the prvious version of Power BI, but it always display zero in YoY in the latest version. Can anyone help?

Formula:

YoY% =

VAR __PREV_YEAR = CALCULATE(SUM('ACT'[COUNT]), DATEADD('ACT'[DATE].[Date], -1, YEAR))

RETURN

DIVIDE((SUM('ACT'[COUNT]) - __PREV_YEAR), __PREV_YEAR)

Display:

[v-easonf-msft]

Hi, @Anonymous 

If your problem has been solved, you could accept the helpful answer as solution. You could also share your own

solution here.

If you still need help, please share a sample file for further research.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@Anonymous , use date table and do not use .date

VAR __PREV_YEAR = CALCULATE(SUM('ACT'[COUNT]), DATEADD('DAte'[DATE], -1, YEAR))

In visual use date, month year, etc from date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.