DateAdd Function

[m_aatif]

While using below mentioned measure, Selecting one year in Pivot table shows values, But if I select all years in column label it ends with an Error.

My Question is can we see all years in Pivot with this function?

DateAdd 1 YrBack:=CALCULATE([TotalSales],DATEADD(Calendar[Date],-1,Year))

 

[Matt Allington]

Yes, that is working as designed. It is like saying "when I select 1 gear in my car it works fine, but when I select 2 gears at once there is a loud crunching sound". The measure you refer to is designed to only work with a single year. You can prevent the "gear crunch" by rewriting the measure as follows.

=if(hasonevalue(calendar[year],CALCULATE([TotalSales],DATEADD(Calendar[Date],-1,Year)))