Power BI Interview Questions- What is difference between calculate and calculatetable in Power BI?
In Power BI, Interview may be asked What is the difference between calculate and calculatetable in DAX/Power BI? Power BI Questions tutorial for freshers and experienced candidates. Get ready to crack Power BI Job Interview.
Medium Blog Link: / power-bi-interview-questions-part-1
Don't forget to like, comment, and subscribe for more great content!
▶️Please Subscribe: / @amitchandak
Complete Power BI in one Video
▶️ • Microsoft Power BI Tutorial For Begin...
▶️ Here is the timestamp of all the topics I have discussed in this tutorial:
00:00 What is the difference between calculate and calculatetable in DAX/Power BI?
00:20 calculate
02:00 calculatetable
🔵 Question 20: What is the difference between calculate and calculatetable in DAX/Power BI?
The main difference between Calculate and CalculateTable in Power BI is that Calculate applies the expression to the current filter context. In contrast, CalculateTable creates a new table with the expression applied to all rows.
Calculate takes as input an expression that evaluates to a scalar and returns a scalar value. This means that the expression can only return a single value, such as a number or a text string. An expression is evaluated in a modified filter context. Table expression filters apply a table object as a filter. A table object could be a reference to a model table, but it is more likely to be a function returning a table object. FILTER can be used to apply complex filter conditions, including those that cannot be defined by Boolean expressions.
Calculate is a function that allows you to calculate an expression in a specific context. Context is the set of filters applied to the measure or expression it is in.
CalculateTable takes as input an expression that evaluates to a table and returns a table. This means that the expression can return a set of rows, such as a list of customers or a list of products. A table expression is evaluated in a modified filter context. FILTER can be used to apply complex filter conditions, including those that cannot be defined by Boolean expressions.
---------
▶️Follow me on:
• Medium: / amitchandak
• Twitter: / amitchandak78
• LinkedIn: / amitchandak78
---------
▶️My Other Videos:
• Mastering Power BI: • Power BI for Beginners 1: Loading Dat...
• Expertise Power BI: • Expertise Power BI- How to Change Con...
~-~~-~~~-~~-~
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
• Microsoft Power BI Tutorial For Begin...
~-~~-~~~-~~-~
