Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unable to make Time intelligence calculation work

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

Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      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