Forum Discussion
Time Intelligence
I think the trouble I'm having may be due to how my company's sales data works.
Each opportunity has a "Close Date" but it's projected or actual. So an opportunity can have a future close date with a status indicating it is "Pending" or it can have a past close date with a status of "closed" or "pending."
Does anyone think this could be messing things up?
Your data model is quite complex, so I haven't attempted to trace the calculations through...but if you filter your sales measures on "closed" opportunities, then that should work ok.
There is some mismatch between your date field in the DimDate table and CloseDate field in the "dpmgr..." table though - even though there is an active relationship between them. And since your sales measures (Sales$MTD, Sales$YTD, etc.) use the DimDate[Date] field, that may be causing some of the issues.
Perhaps try parsing out the date from the date/time CloseDate field and using just the date in your relationship?
Could you possibly elaborate on the mismatch in dates?
Look at my response here and the pictures...
http://community.powerbi.com/t5/Desktop/Count-by-Category/m-p/83368#U83368
The example is different but you'll see what happens when you use different dates!
hope this helps.
Good Luck!:smileyhappy:
Sean ah I see. I made a table including the datekey (dimdate) column and the close date column and one is completely blank where the other isn't.
I'm just not getting it at all, can't seem to figure this stuff out. Thanks for you help, I'm just going to throw in the towel!
