Pg 68 (of my book) shows the resulting Pivot Table that should be achieved when placing Products[Category] on Rows, Calendar[Is Weekend?] on Columns, and [Total Sales Amount] in Values. Calendar[Is Weekend?] is a calculated column with the OR function given in the prior page.
My table shows up when adding the rows and the columns, but once I add the values, the FALSE and TRUE columns disappear and a "(blank)" column is created instead -- so I'm not getting these same results?
Can anyone help me with why? This must be an error on my part as I did not see someone talking about this specifically yet in this forum.
Is it because Product and Calendar are two different tables, and to filter both would require going "Uphill" to the Calendar table?
Thanks for your help!
A dedicated forum to help people when working through the book "Learn to Write DAX"
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest