Forum Discussion

KBrez's avatar
KBrez
Frequent Visitor
3 years ago
Solved

Question: 'Days Out' Measure not interacting with Date Table as expected

Hi All,   I am building a model that compares data year-over-year against an event date that changes each year. I pulled a solution off a forum, and created a calculated column in my date table tha...
General Comment
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    KBrez Columns are not dynamic. They are calculated at the time of data load/refresh.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

KBrez Columns are not dynamic. They are calculated at the time of data load/refresh.

  • KBrez's avatar
    KBrez
    Frequent Visitor
    3 years ago

    Thanks Greg_Deckler . So as a general rule should I avoid referencing Measures in Calculated Columns? 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      KBrez Correct. 99 times out of a 100 it isn't going to work like you want.