Forum Discussion

Frequent Visitor

5 years ago

Solved

PreviousYear() Function doesn't work

I can't figure out why PreviousYear() function doesn't work. What is worng with my formula with PreviousYear()?

There are colums in a table in a report.

Product Category | Calendar Year | Total Sales | Previous Year Sales

1. It doesn't work. It returns blank.

previous year amount 2 =

CALCULATE(sum(FactInternetSales[SalesAmount]), PREVIOUSYEAR(DimDate[FullDateAlternateKey]))

2. It works.

previous year amount =

CALCULATE(sum(FactInternetSales[SalesAmount]), FILTER(all(DimDate), DimDate[CalendarYear] = SELECTEDVALUE(DimDate[CalendarYear])-1))

mahoneypat
Microsoft Employee
5 years ago
Is your Date table "Marked as Date Table"? You are using the alternatekey column in DimDate. Is that the one that was validated when you made the date table?

Regards,

Pat
Greg_Deckler
Community Champion
5 years ago
os_ca You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
os_ca
Frequent Visitor
5 years ago
Thanks all guys for helping me. sorry I can't speak Spanish and no idea how my post ended up here.
English version: https://community.powerbi.com/t5/Desktop/PreviousYear-Function-doesn-t-work/m-p/1484927#M617176