ADDCOLUMNS. Getting Blanks


#1

Hi Sam
Please can you advise me on this, still not figuring why i am getting blanks.
The function works fine as I m getting the correct total for 2014 Sales. However I have blanks.??


#2

Not sure by looking at this. I’ve completed a good review but can’t see the issue directly.

Would have to see a file and test a few things.

Thanks


#3

I believe actually it’s to do with the VALUES( Order breakdown[product name] )

This can’t be joined to the months table as there is no way to filter a sales results concurrently between these two.

Try using the months column from the dates table instead.


#4

Okay thanks will look into this…