Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
What is the difference between measure and calculate column in power BI? When to use calculated column and when to use measures?

1 Answer

0 votes
by (47.2k points)

With calculated columns, you can add new data to a table already in your model. But instead of querying and loading values into your new column from a data source, you create a Data Analysis Expressions (DAX) formula that defines the column's values.

Measures are created and used in Report View or Data View. Measures you create yourself appear in the Fields list with a calculator icon. You can name measures whatever you want, and add them to a new or existing visualization just like any other field.

Want to learn more about Power BI, Come & join Power BI tutorial. Also, enroll in Power BI Microsoft certification course online to become proficient in this BI tool.

Browse Categories

...