Date Forumla

[ZK]

I have a simple date function. The function was created some time back and it works fine. Now, when I copy the same function in the same model it does not recognize the columns which the same function is using. Does anyone have similar experience?

Thank you

[Anonymous · Accepted solution]

This is because in your first example it is being evaulated as a column where as in the second it is a measure.

In a column you can use another column in the formula without aggregating due to the row context. Measures do not have row context so you will need to aggregate the columns. Which aggregation you should use depends on the model.

[praiselyabraham · Accepted solution]

Hi , 

As indicated in the error, you are creating a measure instead of a column , measure's work on aggregated format, where as columns work on row level. This is the reason for your error indicated.

Regards.

[ZK]

Thank you! This was indeed the problem!

[Anonymous · Accepted solution]

This is because in your first example it is being evaulated as a column where as in the second it is a measure.

In a column you can use another column in the formula without aggregating due to the row context. Measures do not have row context so you will need to aggregate the columns. Which aggregation you should use depends on the model.

[ZK]

Hi Thomas!

Thank you so much! I'm a bit embarassed that I did not think about that! Of course this has solved the problem. Thanks!!! 🙂