PowerPivot Forum

Matt has kindly emailed me directly and provided a solution. This is his preferred approach.
You can turn on bi-directional filtering between BudgetPeriod and Calendar, and then hide the BudgetPeriod table and use the Calendar table Period. I think this is the best solution.
Many thanks
Denis

Sorry but this relationship (as you describe it) doesn't work but my direct relationship between BudgetPeriod and Sales does work (and this what is illustrated in the model views in the book

I created a new Column "Period" - Period = (left(Sales[OrderDateKey,6) - in Sales table and used this to relate the two tables. That fixed the problem. Is this a correct solution?
Thanks in advance
Denis

Hi again, On pages 251 and 252, the model view shows a relationship between Sales and BudgetPeriod but this is not referenced in the text and I cannot see how to relate these two tables. However, a relationship is needed as I'm getting the Category total for each period rather than that period's sub...

Think it must be a bug. It's greyed out again.

That's exactly what I did but have just tried again and it works. Do I have to have a visual on the canvas before it will work? That seems to me to be the only difference. In any case, many thanks!

Thoroughly enjoying the book and I have learned a lot. Now in Chapter 17 and when trying to create a "what-if parameter" as described, I find that "New parameter" is greyed out. Can someone help?
Denis Brennan