Career: Mindset & Psychology

  Question: State all the commonly used DAX Functions in Power BI. Suggested Answer: Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot , Power BI Desktop and SQL Server Analysis Services (SSAS) Tabular models. DAX includes some of the functions that are used in Excel formulas with additional functions that are designed to work with relational data and perform dynamic aggregation. DAX data types Integer Real Currency Date (datetime) TRUE/FALSE (Boolean) String Variant Note: The BLOB (binary large object) data type is managed by the Tabular model but cannot be directly manipulated by DAX expressions. Most Common  DAX Function Types with examples 1. Aggregation Functions Calculate sums, averages, counts, etc. SUM() : Total Sales = SUM (Sales[Amount])  // Sum of sales amounts AVERAGE() : Avg Price = AVERAGE (Products[Price])  // Average product price COUNTROWS() : Order Count = COUNTROWS (Orders)  // Number of orde...

Question: How do you create a gauge chart in Power BI? Suggested Answer: A gauge chart (also called a speedometer or radial gauge) visualizes a single metric’s progress toward a goal.  Here’s a step-by-step guide: Step 1: Enable the Gauge Visual Open your Power BI report in Power BI Desktop. In the Visualizations pane, click the Gauge icon (resembles a speedometer). If you don’t see it, click ... (More options) → Get more visuals → Search for "Gauge" and import it. Step 2: Add Data to the Gauge Value : Drag your KPI (e.g., Sales Amount ) to the "Value" field. Target (Optional) : Add a goal (e.g., Sales Target ) to the "Target" field. Minimum/Maximum (Optional) : Manually set the gauge’s scale range by typing values in the " Minimum " and " Maximum " fields under Format → Gauge axis . Or, drag columns to " Minimum Value " and " Maximum Value " (e.g., 0 to 100%).

  What is the role of the M language in Power BI? Suggested Answer: The M language (also called Power Query Formula Language) is a critical component of Power BI, primarily used for data extraction, transformation, and loading (ETL). Here’s a detailed breakdown of its role: 1. Primary Role: Data Transformation M is the backbone of Power Query Editor, where it: Cleanses (e.g., removes duplicates, fixes errors). Reshapes (e.g., pivots/unpivots, splits columns). Enriches (e.g., merges tables, adds custom columns). Filters (e.g., removes irrelevant rows/columns). Example: m = Table.SelectRows(Source, each [Sales] > 1000) // Filters rows where sales exceed 1000 2. Key Features of M a) Declarative & Functional M scripts describe what to do (not step-by-step how), making it intuitive. Uses functions (e.g., Table.ReplaceValues, Text.Trim) and nested expressions. b) Query Folding Pushes transformations back to the source system (e.g., SQL Server) to improve performance. Example: A WH...