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
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.
Time Intelligence in Analytics: Trends and Seasonality
Time intelligence for analysts, worked through two years of real daily bike-share data: why a 23% monthly fall was good news, smoothing daily noise with moving averages, year-to-date comparisons, seasonal indexes, weekday effects, and the partial-period trap that turned a 4.5% rise into a 48% fall.