Power Pivot - Time Intelligence Measure and pivot table

[cmajka]

Hi All -

I have created a time intelligence measure that calcs YOY growth as a percentage. The issue I am seeing is that when I insert it into my pivot table (and ultimately my pivot chart), it is showing data points for future months. For instance, I want to refresh the pivot each month when the new data becomes available. This month, we have data through July 2016. However, the since I've added the measure, there is a -100% value showing for Aug, Sept, Oct, etc. How can I remove these so these future months aren't showing in my pivot chart? As an aside, the chart should show the previous 13 months worth of data.

Thanks

 

[Matt Allington]

2 options. Read my blog post here and build a calendar table with no future dates. This works generally unless you have budgets and forecasts that you want to see. Create a Custom Calendar in Power Query - PowerPivotPro

otherwise, wrap everything relying on past years in an if statement.

If countrows of data table this year = 0 then display BLANK.

 

[cmajka]

Fantastic - thanks Matt! I will share this method with the rest of my team.