IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
DAX Guide: Measures, Calculated Columns and Context
The foundations of DAX in Power BI: the five places a calculation can live, how to decide between a measure and a calculated column, what row context and filter context mean, why an averaged margin column came out at nearly double the true margin on real data, iterators, and habits for writing reliable measures.
Time Intelligence in DAX: YTD, MTD and Comparisons
DAX time intelligence for Power BI: the date table it depends on, year-to-date and month-to-date measures, fiscal year ends, prior-year comparisons with SAMEPERIODLASTYEAR and DATEADD, rolling windows with DATESINPERIOD, and the partial-month trap that turned a 62.7% increase into an 8.6% fall, shown with real numbers.
DAX CALCULATE Function Explained Step by Step
The DAX CALCULATE function explained step by step, with real sales numbers for every measure: how a filter argument overwrites the visual's filter, why a UK revenue measure shows the UK total on every row, how KEEPFILTERS and REMOVEFILTERS change that, and how context transition makes calculated columns work.
Top 20 DAX Functions Every Analyst Should Know
Twenty DAX functions that cover most Power BI reporting, grouped by job: counting and summing, iterators such as SUMX, CALCULATE and its filter modifiers, relationship functions, logic and safe division, SELECTEDVALUE and VALUES, time intelligence, and RANKX, each with an example measure and the mistake to avoid.
DAX Variables: Writing Cleaner, Faster Measures
DAX variables explained with real numbers: VAR and RETURN syntax and naming rules, how variables speed up and simplify measures, debugging by returning a variable, the rule that a variable is fixed where it is declared, shown producing a 100% share by mistake, and replacing EARLIER in a ranking column.
DAX FILTER and ALL Functions Explained
The DAX FILTER and ALL functions explained with real sales numbers: how ALL on a table or a column produces three different shares of total, what ALLEXCEPT, ALLSELECTED and REMOVEFILTERS change, when FILTER is genuinely needed, such as conditions on measures, and why Microsoft recommends Boolean filters where possible.