Power BI Time Intelligence DAX Functions in தமிழில்

In this lecture, you’ll learn how to use the PREVIOUSMONTH() DAX function to analyse data from the previous calendar month in Power BI. This is a must-know function for time-based reporting such as month-over-month comparison, sales trend analysis, and performance tracking.

We’ll start by explaining the syntax and how it works with a proper calendar table. Then, we’ll walk through a real-world use case, where we compare current month sales with the previous month’s sales using a combination of PREVIOUSMONTH() and CALCULATE().

By the end of this video, you’ll understand:

1. When and why to use PREVIOUSMONTH()

2. How it behaves with your date table

3. How to avoid common issues with missing dates

How to apply it in a real Power BI visual

This lecture is taught in Tamil with all DAX functions and concepts explained clearly in English, making it easy to follow for Tamil-speaking Power BI learners.

In this video, you’ll learn how to use the TOTALYTD() DAX function in Power BI to calculate year-to-date (YTD) values. We’ll break down the syntax, explain when to use it, and walk through a real-time demo real time data

This lecture is in Tamil with DAX explained in English — making it easy to follow for Tamil-speaking learners.

In this lecture, you’ll learn how to use the DATESQTD() DAX function to calculate Quarter-to-Date (QTD) values in Power BI reports. This function is ideal when you want to track cumulative performance from the start of a quarter up to a specific date — such as Q1 Sales or Q2 Profits.

We’ll start by understanding the syntax of DATESQTD() and how it interacts with your calendar table. Then, you’ll walk through a step-by-step demo that shows how to combine this function with CALCULATE() to create QTD measures.

You’ll also learn how DATESQTD() compares with TOTALYTD() and when to use one over the other, especially in dashboards with quarterly reporting needs.

By the end of this lecture, you’ll be able to:

1. Use DATESQTD() to compute quarter-to-date totals

2. Combine it with other DAX functions like CALCULATE()

3. Build dynamic quarterly KPIs and visualizations

Ensure proper behaviour using a continuous calendar table

As always, this lecture is presented in Tamil with all technical explanations and DAX formulas clearly broken down in English — helping you build confidence in applying Time Intelligence logic in real-world projects.

In this lecture, you’ll learn how to use the DATEADD() DAX function to shift the date context forward or backward — by days, months, quarters, or years. This function is perfect for comparing values such as sales from the previous year, next quarter, or same day last month.

We’ll explore the syntax, how it works inside CALCULATE(), and when to use it instead of other time intelligence functions like SAMEPERIODLASTYEAR. Through a practical demo in Power BI, you’ll build dynamic visuals that rely on time-based comparisons.

By the end of this video, you’ll be able to:

1. Use DATEADD() to move the date context by any time unit

2. Create custom comparisons (e.g., last 3 months vs. current 3 months)

3. Understand behaviour with filters and visuals

Apply it inside real-time dashboards confidently

This session is in Tamil, with DAX and logic explained clearly in English for easy understanding.

In this lecture, you’ll learn how to use the DATESBETWEEN() DAX function to filter a custom range of dates in Power BI. This is one of the most flexible time intelligence functions, ideal for calculating values between any two specific dates — like last 90 days, custom fiscal quarters, or campaign date ranges.

We’ll explore the function’s syntax, how to define the start and end date dynamically or manually, and use it in real-time dashboards. You’ll also see how DATESBETWEEN() differs from DATEADD() and other functions.

By the end of this session, you’ll be able to:

1. Filter data between any two dates using DATESBETWEEN()

2. Combine it with CALCULATE() for dynamic KPIs

3. Use it in dashboards for rolling periods, custom quarters, and more

4. Avoid common mistakes with non-continuous dates or mismatched formats

This lecture is explained in Tamil, with technical parts like syntax and DAX formulas in English, for easy understanding and practical use.

In this lecture, you’ll learn how to use the DATESINPERIOD() function in DAX to create rolling time periods in Power BI — like the last 30 days, last 6 months, or past 1 year. This function is essential for building dynamic dashboards with moving windows of data.

We’ll cover the syntax and parameters such as start date, number of intervals, and interval type (DAY, MONTH, YEAR, etc.). You’ll also learn how it differs from DATESBETWEEN() and why it’s more suitable for relative time filtering.

By the end of this lecture, you’ll be able to:

1. Use DATESINPERIOD() for rolling time-based KPIs

2. Create visuals like “Last 90 Days Sales” or “Past 12 Months Revenue”

3. Combine it with CALCULATE() for dynamic filtering

4. Understand use cases where DATESINPERIOD() is better than DATEADD() or DATESBETWEEN()

This session is taught in Tamil, with DAX formulas and concepts explained in English, making it simple and effective for bilingual learners.

In this lecture, you'll learn how to use the PREVIOUSYEAR() DAX function in Power BI to calculate values from the entire previous year. This is one of the most used functions for Year-over-Year (YoY) analysis, such as comparing current sales with last year’s performance.

You’ll understand the syntax, learn how it works with a calendar table, and explore how to use it inside CALCULATE() for dynamic YoY calculations. Through a live demo, you’ll see how this function helps you create visuals like YoY growth, previous year totals, and trend analysis.

By the end of this lecture, you’ll be able to:

1. Use PREVIOUSYEAR() to return last year’s date range

2. Combine it with CALCULATE() to compute previous year values

3. Build YoY reports and visuals easily

4. Understand the role of a proper date table in time intelligence

This session is taught in Tamil, with DAX formulas and logic explained clearly in English, for an effective bilingual learning experience.

In this lecture, you’ll explore how to use the PARALLELPERIOD() function in DAX to shift the date context by a fixed number of intervals — whether it's months, quarters, or years — without relying on today’s date. This function is extremely useful for building flexible time comparisons like “same quarter last year” or “3 months before current period.”

We’ll break down the syntax and compare it with similar time functions like DATEADD(). Using a step-by-step Power BI demo, we’ll calculate past performance (e.g., sales 1 year ago, 1 quarter ago) using PARALLELPERIOD().

By the end of this session, you’ll be able to:

1. Use PARALLELPERIOD() to shift time backward or forward

2. Compare with DATEADD() and understand when to use each

3. Create dynamic visuals like YoY/QoQ change

4. Use it effectively in CALCULATE() for custom date logic

This session is in Tamil, with DAX and logic clearly explained in English to make your learning smooth and practical.

In this lecture, you’ll learn how to use the SAMEPERIODLASTYEAR() DAX function to perform year-over-year (YoY) comparisons in Power BI. This function allows you to easily calculate values for the same period (day/month/quarter) in the previous year, making it a popular choice for tracking growth and trends.

We’ll walk through the syntax and show how it works with a properly configured calendar table. Using a hands-on demo, you’ll create YoY visuals like Current Month vs. Last Year’s Month, and compare it with alternatives like DATEADD() and PARALLELPERIOD().

By the end of this video, you’ll be able to:

1. Use SAMEPERIODLASTYEAR() for clean year-over-year comparisons

2. Build visuals comparing this year’s vs last year’s values

3. Understand when to use it over DATEADD() or PREVIOUSYEAR()

4. Apply it inside CALCULATE() for dynamic metrics

This video is delivered in Tamil, with all technical DAX logic explained clearly in English, giving you the best bilingual learning experience.

In this short lecture, you'll learn about the UTCTODAY() DAX function, which returns the current date in Coordinated Universal Time (UTC). This is helpful when your reports are hosted in the cloud (like Power BI Service) and need consistent time references regardless of user location.

We’ll explain the syntax, difference between TODAY() and UTCTODAY(), and when to use it for refresh-dependent logic like daily KPIs or date-based filters.

By the end of this video, you’ll be able to:

1. Use UTCTODAY() for time-zone-independent reports

2. Understand the difference between local vs UTC dates

3. Use it safely in Power BI Service auto-refresh scenarios

4. Avoid time zone-based errors in calculations

This video is taught in Tamil, with technical DAX concepts explained in English for easy understanding.

In this lecture, you'll explore how to use the UTCNOW() DAX function, which returns the current date and time in UTC. It’s especially useful in Power BI Service when building reports that depend on precise timestamps unaffected by the user’s local time zone.

You’ll learn the syntax and see how to use UTCNOW() in dynamic refresh logic, timestamp tracking, or last refresh time displays.

By the end of this lecture, you’ll be able to:

1. Use UTCNOW() to capture the current UTC timestamp

2. Build dashboards with accurate, globally consistent time logic

3. Know when to choose NOW() vs UTCNOW()

4. Use it to display report refresh time or filter time-sensitive data

This is a quick and clear session in Tamil, with technical portions in English.

You’ll review key learnings, get practical tips to use DAX time functions confidently, and learn the next steps to continue your Power BI journey in Tamil.