Unable to make Time intelligence calculation work

[Anonymous]

I have a Sales table (Fact) and a Calender date table, which is marked as the "date table". Both table is linked by the date column in both tables on a 1 to many basis. Calendar table on the 1 side of the relationship.

I can get month to date calculation to work if i reference the date column in the Sales table but not if i reference the date column in the Calender table.

Basically non of the time intelligence measures work if i reference the Calender date column in the measure.

What am i doing wrong? Can any offer a solution? Thanks in advance

[Anonymous]

Seems like they should work just fine...Can you post some sample data and the measures you have created?

[Anonymous]

---

@Anonymous wrote:

Seems like they should work just fine...Can you post some sample data and the measures you have created?

---

Sample View

Sales MTD = TOTALMTD([Sales Total],G_Margin[Date]) - This works but using the fact table date column and not the "Dates"date colmun.

Sales LastMnth = Calculate([Sales Total],PREVIOUSMONTH(Dates[Date])) - Does not return a figure.

Any suggestion?

Thank you