Forum Discussion
star schema
What is calculated columns.
I am trying to create a calculated column in the dimension table but I couldn't get specific tables it is showing red color. The same applies to the fact table during IF condition
2 Replies
What is "an"? If it's a table, then it doesn't belong as a boolean in front of "||". If it's a column name, then you need to use brackets [an] (preferably fully qualified as TableName[an]).
Hi AtchayaP,
Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
