Forum Discussion

ap's avatar
ap
Icon for Advocate I rankAdvocate I
9 years ago

Problems with time intelligence in a role playing calendar table (MTD and QTD)

I'm using a role playing calendar table but running into problems when using time dimensions particularly MTD and QTD   I have a closed date and proposal due date all in one calendar table (DimClos...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

ap,

Could you please share sample data of your fact table and calendar table? What field you use to create relationship between the two tables?

Also, we need to know what formula you use to create [Total Sales Closed ($CAD)] and what is the result when you use the following DAX to calculate MTD.

Total Sales Closed ($CAD) MTD= TOTALMTD(SUM(FactOpportunity[column]), FactOpportunity[Closed Date])

Regards,