Forum Discussion

rokesh18's avatar
rokesh18
New Member
3 years ago
Solved

Creating a Dynamic Column based on 'What if' Parameters

Hi,   I created a Custom Column with the following formula.   Type = IF(Column A >= Parameter1,                  IF(Column B >=Parameter2,"Star","Question"),                  IF(Column B >=Par...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    3 years ago

    There is no such thing as a dynamic column.  Calculated columns cannot be created through measures. They are only calculated once, during dataset refresh*.

     

    * one small exception is when you have a composite data model with dataset as  a source and a local copy of the model but even then it is limited to in-row calculations.

lbendlin's avatar
lbendlin
Super User
3 years ago

There is no such thing as a dynamic column.  Calculated columns cannot be created through measures. They are only calculated once, during dataset refresh*.

 

* one small exception is when you have a composite data model with dataset as  a source and a local copy of the model but even then it is limited to in-row calculations.