Prevent blank columns

[nikkollai]

Hello,

My data does not have a year column, so i am using YEAR() function to pull years from full date column in the same table. =YEAR([DATE]) . It iterates well and i have not blanks in powerpivot.
But when i am breaking my model by years in excel for some reason i am getting additional blank column
Does anybody know what could cause this and how can i get rid of it?

[TABLE="width: 500"]
<tbody>[TR]
[TD]2012
[/TD]
[TD]2013
[/TD]
[TD]2014
[/TD]
[TD]2015
[/TD]
[TD](blank)
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Tks, Nick

 

[cyrilbrd]

Hi, is your raw data a table or just an array?
if within PT you may opt NOT to display blanks.

 

[nikkollai]

Hi,
I am getting the extra column (with blank) in PT when i transfer the data from powerpivot into PT excel.
I think i should be creating an extra table for calendar and linking everything together but it really bothers me why i cannot figure out the reason for that extra column.
By the way how do you OPT out not to show blanks in PT?
N -

 

[cyrilbrd]

Hi,
I am getting the extra column (with blank) in PT when i transfer the data from powerpivot into PT excel.
I think i should be creating an extra table for calendar and linking everything together but it really bothers me why i cannot figure out the reason for that extra column.
By the way how do you OPT out not to show blanks in PT?
N -

if your data is in Column Labels, click on the small arrow in the PT near the word "Column Labels" and deselect (blanks).

 

[scottsen]

You should be able to see which rows are returning blank. In PP, on this table where you added the YEAR() calc column... drop it down, select only the BLANK(), and see what's up?