Forum Discussion

santhiya's avatar
santhiya
Helper I
3 years ago

Refreshing Behaviour for Calculated Columns

Hi Community !!
I created  a calculated column with DAX in Table A that is based on a column in another Table(lets say Table B) . As Calculated column is calculated  on every refresh what if my table A refreshed before Table B. How this works Internally ?

Thanks in Advance .


Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    santhiya I believe the order of operations is, all tables get refreshed, then calculated columns are calculated.

    • santhiya's avatar
      santhiya
      Helper I
      3 years ago

      Greg_Deckler  Thanks, I have Used Calculated column instead of Measure for the stated case .Any suggestion for using calculated column or measure  for the above problem?  In which scenario we need to use calculated column / measures?