Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
What are the main differences between a calculated column and a measure?
Calculated columns must be written in SQL, while measures must be written in Python. Neither uses the DAX language.
Calculated columns can only store text data (strings), whereas measures are strictly limited to numeric currency values.
A calculated column computes a value for every row and stores it in the file (consuming memory), while a measure calculates results on the fly (dynamic aggregation) based on the user's current view/filters.
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!