You would need to bring the dimensions in the new table. Please share sample data of your table or your PBIX file here.
Hey Lydia....I've added a dimension (Channel) to your model to show you want I mean. The 1st issue is the total is not rolling up properly. See in screenshot below...total is showing $50 for Jan...should be $100. Taking the 'max' of the row is not allowing the amounts to be dynamic and sum up properly when adding dimensions.
I see what it's doing now. It's actually taking the Rev when I create the new table and applying it to each 'day' in the dates. I only need my dates to reflect the month...so just 1/1/2017 for example. I need the dates to reflect a single day and that would fix it. Thoughts?