Results for "calendar"

4 / 4 posts

Search: calendar
SQLPythonPySparkMachine learningPower BIData WorldNumPyADF

Filter by Category

DATA
Power BI

Date Time in Power BI

In Power BI and DAX, the CALENDAR() and CALENDARAUTO() functions are used to generate a table of dates. These functions are particularly useful for creatin…

calendar google journal
Match in tagsMatch in contentMatch in code
Mar 19, 2026 2 min read
DATA
SQL

Dynamic Date Series in SQL Server (Financial Year + Calendar Year Handling)

When working with reports, analytics, or dashboards in SQL Server, one common requirement is generating a continuous date series between two dates — especial...

SQLServer TSQL DateSeries
Match in titleMatch in tagsMatch in content
Mar 19, 2026 6 min read
DATA
Power BI

Basic Functions in Power BI

SUMX : This function is used to evaluate an expression for each row. It's useful when you need to perform calculations on a row-by-row basis before aggrega…

Power BI
Match in contentMatch in code
Mar 19, 2026 6 min read
DATA
Pandas

Advanced Pandas: Performance, Time Series, ML Pipelines & Interview Questions (Part 3)

Master advanced Pandas — MultiIndex, time series resampling, rolling windows, memory optimization, Pandas 2.x features, ML pipelines, and 30+ interview Q&A.

pandas advanced pandas time series pandas performance
Match in contentMatch in code
Apr 15, 2026 27 min read

SQLDataDev footer

SQLDataDev

Practical SQL, Python, analytics, and data engineering tutorials for builders who learn by shipping.

Browse practical tutorials for SQL, Python, analytics, and data engineering with crawlable internal links that help readers discover related articles quickly.

Explore

  • SQL
  • Python
  • PySpark
  • Machine learning
  • Power BI
  • Data World

Categories

  • Data Science
  • Database maintenance

Tools

  • SQL Formatter
  • All Tools

Search & Indexing

  • Homepage
  • About
  • Main Sitemap
  • Post Archive
  • Contact Us
  • Robots Rules

Copyright 2026 SQLDataDev. Practical tutorials for data builders.

Everything's organized so you can discover exactly what you're looking for — browse by category, search the archive, or explore related posts.