Power BI DAX - Text Functions & DateTime Functions
Power BI Weekly: Session 13
DAX Part 2 | Text Functions & Date/Time Functions in Power BI
In this session, we continued our DAX journey by focusing on Text and Date/Time functions — key tools for building meaningful and dynamic calculations in Power BI.
After learning DAX fundamentals, CALCULATE, filter context, and IF logic, this session shows how to work with text and dates effectively.
📚 WHAT YOU’LL LEARN:
🔤 Text Functions in DAX
Combining text using CONCATENATE and &
Extracting characters using LEFT and RIGHT
Counting characters using LEN
Changing text format using UPPER and LOWER
Real examples like Full Name, City Code, Email Domain
📅 Date & Time Functions
Extracting Year, Month, Day from dates
Using TODAY() and NOW()
Creating Month Names
Calculating time differences (e.g. Days Since Order)
Building dynamic time-based calculations
⚙️ Combining Functions
Using multiple DAX functions together
Applying logic with IF + CALCULATE
Building real-world business calculations
💡 Key Insight:
DAX is not just about writing formulas.
It’s about transforming data into meaningful insights using logic, text, and time.
This session builds on previous DAX classes and prepares you for creating complete reports.
📚 Full Playlist:
• PowerBi Weekly
📅 Live Classes:
Tuesdays & Thursdays
6pm WAT | 8pm EAT | 10:30pm IST
Follow the series as we move from data preparation to full report building.
#PowerBI #DAX #DataAnalytics #BusinessIntelligence #PowerBITutorial