Forum Discussion

jfern78's avatar
jfern78
Frequent Visitor
2 years ago

Calculate % difference between two years

I would like to work out % difference between 2 years for a set of values and having some trouble doing so.   First of all, let’s say I have the following sample of data   Year Active/Inacti...
jfern78's avatar
jfern78
Frequent Visitor
2 years ago

i made a column with correct FY Year/date, but when i try to calculate last year sales return me blank.

 

Total Sales Last Year = CALCULATE([Total Cartera Activa],dateadd('Cartera Total'[Fiscal Date],-1,Year))

 

some_bih's avatar
some_bih
Community Champion
2 years ago

Hi jfern78 use Date / Calendart table to "leverage" proper usage of Power BI time intelligence functions like YTD, MTD... do not put fact table year column in visual.