Comparing Dates in Power BI - Data and Graphing Activities with Solutions

Master comparing dates in Power BI: DATE functions, comparison methods, and data visualization through these 10 detailed exercises.

Solutions: Exercises 1 to 10
1 Date Creation
Exercise 1
How do I create a date for March 15, 2024 in Power BI using DAX?
Difficulty: Beginner Time: ~3 minutes Skills: DATE Function, DAX Syntax
Definition:

Date creation in Power BI: Using DAX (Data Analysis Expressions) functions to create and manipulate date values.

Note: Power BI uses DATE function in DAX with year, month, day parameters.

Step-by-step date creation:
  1. Use the DATE function: DATE(year, month, day)
  2. Follow the Y-M-D parameter order
  3. Store the result in a measure or column
DAX Function
DATE(2024,3,15)
Result
March 15, 2024
Step 1: Use DATE function

DATE(2024,3,15) creates March 15, 2024.

Step 2: Execute in Power BI

Power BI processes the date function.

Step 3: Verify result

The result shows March 15, 2024 in the appropriate format.

DATE(2024, 3, 15)
DATE(2024,3,15) creates March 15, 2024.
Final answer:

Use DATE(2024,3,15) to create March 15, 2024.

Applied rules:

• Function syntax: DATE(year, month, day) in that order

• Parameter format: Use numbers for year, month, day

• Zero-padding: Months and days should be valid numbers

• Practice Tip: Remember Y-M-D order for DATE function

Related Examples:
  • DATE(2023,12,25) -- Christmas 2023
  • DATE(2024,1,1) -- New Year 2024
  • DATE(2024,10,31) -- Halloween 2024
Quick Tips:
  • Always use numbers for date parameters
  • Months are 1-12 (not 0-11 like in some programming languages)
  • Power BI handles leap years automatically
Frequently Asked Questions:

Q: What if I use an invalid date?
A: Power BI will return an error. For example, DATE(2024,2,30) fails because February doesn't have 30 days.

Q: Can I include time in the DATE function?
A: No, DATE only creates dates. Use DATETIME functions for date and time.

2 Date Comparison
Exercise 2
How do I compare two dates in Power BI? Is March 15, 2024 earlier than March 20, 2024?
Difficulty: Beginner Time: ~3 minutes Skills: Date Comparison, DAX Operators
Definition:

Date comparison: Using comparison operators (<, >, =) to determine the relationship between two dates in Power BI.

Note: Power BI compares dates based on their internal representation.

Step-by-step comparison method:
  1. Create two DATE expressions
  2. Use comparison operator (<, >, =) between them
  3. Evaluate the boolean result
Dates
March 15 vs March 20
Comparison
True
Step 1: Create comparison expression

DATE(2024,3,15) < DATE(2024,3,20)

Step 2: Execute in Power BI

Power BI evaluates the comparison and returns true/false.

Step 3: Interpret result

Since March 15 is before March 20, the result is true.

DATE(2024, 3, 15) < DATE(2024, 3, 20)
DATE(2024,3,15) < DATE(2024,3,20) returns true.
Final answer:

Yes, March 15, 2024 is earlier than March 20, 2024.

Applied rules:

• Comparison operators: Use <, >, = to compare dates

• Boolean result: Comparison returns true or false

• Chronological order: Earlier dates are less than later dates

• Practice Tip: Test with known date relationships first

Related Examples:
  • DATE(2024,1,1) < DATE(2024,12,31) -- returns true
  • DATE(2024,5,15) > DATE(2024,3,10) -- returns true
  • DATE(2024,4,1) = DATE(2024,4,1) -- returns true
Quick Tips:
  • < means "is earlier than", > means "is later than"
  • Power BI stores dates as numbers internally for comparison
  • Time components matter in date comparisons if present
Frequently Asked Questions:

Q: What comparison operators can I use?
A: You can use all comparison operators: <, >, <=, >=, =, <>

Q: Does time matter in date comparison?
A: Yes! If dates include time, Power BI compares both date and time components.

3 Greater Than
Exercise 3
Is June 10, 2024 greater than March 15, 2024 in Power BI? Use the > operator.
Difficulty: Beginner Time: ~4 minutes Skills: Date Comparison, Greater Than, DAX Operators
Definition:

Greater than (>): Operator that returns true if the left operand is later in time than the right operand.

Note: For dates, "greater than" means chronologically later.

Step-by-step greater than method:
  1. Create two DATE expressions
  2. Use the > operator between them
  3. Evaluate the boolean result
Dates
June 10 vs March 15
Result
True
Step 1: Create comparison expression

DATE(2024,6,10) > DATE(2024,3,15)

Step 2: Execute in Power BI

Power BI evaluates the comparison and returns true.

Step 3: Interpret result

Since June 10 is after March 15, the result is true.

DATE(2024, 6, 10) > DATE(2024, 3, 15)
DATE(2024,6,10) > DATE(2024,3,15) returns true.
Final answer:

Yes, June 10, 2024 is greater than March 15, 2024.

Applied rules:

• Greater than: > operator returns true if left date is later

• Chronological logic: Later dates are greater than earlier dates

• Boolean evaluation: Result is always true or false

• Practice Tip: Think of the number line for date ordering

Related Examples:
  • DATE(2024,12,31) > DATE(2024,1,1) -- returns true
  • DATE(2024,8,15) > DATE(2024,8,10) -- returns true
  • DATE(2024,2,1) > DATE(2024,12,31) -- returns false
Quick Tips:
  • > means "comes later in time"
  • Think of dates on a timeline from left to right
  • Any date in June > any date in March of the same year
Frequently Asked Questions:

Q: What if I compare dates in different years?
A: The year is considered first, then month, then day. DATE(2023,12,31) < DATE(2024,1,1) returns true.

Q: Can I chain multiple comparisons?
A: Yes! You can use expressions like date1 > date2 AND date2 > date3.

Solutions: Exercises 4 to 5
4 Less Than
Exercise 4
Is January 1, 2024 less than February 14, 2024 in Power BI? Use the < operator.
Definition:

Less than (<): Operator that returns true if the left operand is earlier in time than the right operand.

Note: For dates, "less than" means chronologically earlier.

Step-by-step less than method:
  1. Create two DATE expressions
  2. Use the < operator between them
  3. Evaluate the boolean result
Dates
Jan 1 vs Feb 14
Result
True
Step 1: Create comparison expression

DATE(2024,1,1) < DATE(2024,2,14)

Step 2: Execute in Power BI

Power BI evaluates the comparison and returns true.

Step 3: Interpret result

Since January 1 is before February 14, the result is true.

DATE(2024, 1, 1) < DATE(2024, 2, 14)
DATE(2024,1,1) < DATE(2024,2,14) returns true.
Final answer:

Yes, January 1, 2024 is less than February 14, 2024.

Applied rules:

• Less than: < operator returns true if left date is earlier

• Chronological logic: Earlier dates are less than later dates

• Boolean evaluation: Result is always true or false

• Practice Tip: Remember: < means "earlier than"

Related Examples:
  • DATE(2024,1,1) < DATE(2024,12,31) -- returns true
  • DATE(2024,5,1) < DATE(2024,5,15) -- returns true
  • DATE(2024,10,31) < DATE(2024,9,15) -- returns false
Quick Tips:
  • < means "comes earlier in time"
  • Think of the calendar year from January to December
  • Any date in January < any date in February of the same year
Frequently Asked Questions:

Q: What happens if I compare the same dates?
A: DATE(2024,5,1) < DATE(2024,5,1) returns false since they're equal.

Q: Can I use <= for "less than or equal"?
A: Yes! DATE(2024,5,1) <= DATE(2024,5,1) returns true.

5 Equal Dates
Exercise 5
Are March 15, 2024 and March 15, 2024 equal in Power BI? Use the = operator.
Definition:

Equality (=): Operator that returns true if both operands represent the same date and time.

Note: For dates, equality means identical year, month, and day.

Step-by-step equality method:
  1. Create two DATE expressions
  2. Use the = operator between them
  3. Evaluate the boolean result
Dates
March 15 vs March 15
Result
True
Step 1: Create comparison expression

DATE(2024,3,15) = DATE(2024,3,15)

Step 2: Execute in Power BI

Power BI evaluates the comparison and returns true.

Step 3: Interpret result

Since both dates are identical, the result is true.

DATE(2024, 3, 15) = DATE(2024, 3, 15)
DATE(2024,3,15) = DATE(2024,3,15) returns true.
Final answer:

Yes, March 15, 2024 and March 15, 2024 are equal.

Applied rules:

• Equality: = operator returns true if dates are identical

• Exact match: Year, month, and day must all match

• Boolean evaluation: Result is always true or false

• Practice Tip: Use = to check for specific dates

Related Examples:
  • DATE(2024,12,25) = DATE(2024,12,25) -- returns true
  • DATE(2024,1,1) = DATE(2023,1,1) -- returns false
  • DATE(2024,7,4) = DATE(2024,7,4) -- returns true
Quick Tips:
  • = checks for exact date match
  • Year, month, and day must all be the same
  • Use for validating specific dates like birthdays
Frequently Asked Questions:

Q: What if dates have different times?
A: If you include time components, they must also match for equality.

Q: Can I check inequality with <>?
A: Yes! DATE(2024,3,15) <> DATE(2024,3,16) returns true.

Solutions: Exercises 6 to 10
6 Current Date Function
Exercise 6
How do I get today's date in Power BI and compare it with March 10, 2024?
Definition:

TODAY function: Returns the current date in Power BI. Updates automatically each day.

Note: TODAY() takes no arguments and returns the current date.

Step-by-step current date method:
  1. Use TODAY() in an expression
  2. Compare with another date using operators
  3. Power BI evaluates the comparison based on current date
Function
TODAY()
Comparison
Variable
Step 1: Get current date

Use TODAY() to get the current date.

Step 2: Compare with another date

TODAY() > DATE(2024,3,10)

Step 3: Evaluate result

Result depends on when you run the flow.

TODAY()
TODAY() returns current date; comparison depends on current date.
Final answer:

Use TODAY() to get today's date and compare with other dates.

Applied rules:

• TODAY function: No arguments needed, returns current date

• Dynamic update: Changes automatically each day

• Comparison logic: Works with all comparison operators

• Practice Tip: Use for relative date comparisons

Related Examples:
  • TODAY() < DATE(2025,1,1) -- checks if today is before 2025
  • TODAY() = DATE(2024,3,15) -- checks if today is March 15, 2024
  • TODAY() > DATE(2023,12,31) -- checks if today is after 2023
Quick Tips:
  • TODAY() updates automatically each day
  • Use for calculating days until future dates
  • Combine with other functions for complex date logic
Frequently Asked Questions:

Q: When does TODAY() update?
A: It updates automatically each day when the report refreshes.

Q: Can I get just the date part?
A: TODAY() only returns the date part by default.

7 Date Difference
Exercise 7
How many days are between March 10, 2024 and March 20, 2024 in Power BI?
Definition:

Date difference: Calculating the number of days between two dates using Power BI functions.

Note: Use DATEDIFF function to calculate date differences.

Step-by-step date difference:
  1. Create two DATE expressions
  2. Use the DATEDIFF function between them
  3. Specify the interval (day)
Date Range
March 10 to March 20
Days Difference
10 days
Step 1: Calculate difference

DATEDIFF(DATE(2024,3,20), DATE(2024,3,10), DAY)

Step 2: Execute in Power BI

Power BI calculates the difference between the dates.

Step 3: Interpret result

Power BI returns 10, meaning 10 days difference.

DATEDIFF(DATE(2024, 3, 20), DATE(2024, 3, 10), DAY)
DATEDIFF returns 10 days between March 10 and March 20, 2024.
Final answer:

There are 10 days between March 10, 2024 and March 20, 2024.

Applied rules:

• Subtraction: Later date minus earlier date gives positive days

• Positive result: Always subtract earlier from later for positive difference

• Day calculation: DATEDIFF returns difference as integer days

• Practice Tip: Remember: Larger date - Smaller date = Positive result

Related Examples:
  • DATEDIFF(DATE(2024,1,10), DATE(2024,1,1), DAY) -- returns 9
  • DATEDIFF(DATE(2024,12,25), DATE(2024,12,1), DAY) -- returns 24
  • DATEDIFF(DATE(2025,1,1), DATE(2024,12,31), DAY) -- returns 1
Quick Tips:
  • Subtract earlier date from later date for positive result
  • Power BI handles leap years automatically in calculations
  • For inclusive ranges, add 1 to the result
Frequently Asked Questions:

Q: What if I subtract a later date from an earlier date?
A: You get a negative number. DATEDIFF(DATE(2024,3,10), DATE(2024,3,20), DAY) returns -10.

Q: Does Power BI account for leap years in differences?
A: Yes, Power BI handles leap years automatically when calculating date differences.

8 Age Calculation
Exercise 8
How do I calculate someone's age in years if they were born on January 1, 2010 and today is January 1, 2024 in Power BI?
Definition:

Age calculation: Determining the number of complete years between a birth date and a reference date.

Note: Use DATEDIFF function with YEAR interval to calculate age.

Step-by-step age calculation:
  1. Create birth date and reference date expressions
  2. Use DATEDIFF function with YEAR interval
  3. Power BI returns the number of complete years
Birth Date
Jan 1, 2010
Reference Date
Jan 1, 2024
Age
14 years
Step 1: Calculate years difference

DATEDIFF(TODAY(), DATE(2010,1,1), YEAR)

Step 2: Execute in Power BI

Power BI calculates the difference in years.

Step 3: Interpret result

The person is 14 years old on January 1, 2024.

DATEDIFF(TODAY(), DATE(2010, 1, 1), YEAR)
Age = 14 years (born January 1, 2010; reference date January 1, 2024).
Final answer:

The person is 14 years old on January 1, 2024.

Applied rules:

• Years difference: Calculate using DATEDIFF with YEAR interval

• Age calculation: Use reference date minus birth date

• Complete years: DATEDIFF returns complete years only

• Practice Tip: Use TODAY() for dynamic age calculations

Related Examples:
  • DATEDIFF(DATE(2024,1,2), DATE(2010,1,1), YEAR) -- returns 14
  • DATEDIFF(DATE(2024,1,1), DATE(2010,6,15), YEAR) -- returns 13 (birthday not passed)
  • DATEDIFF(DATE(2024,1,1), DATE(2010,12,31), YEAR) -- returns 13 (birthday not passed)
Quick Tips:
  • Use DATEDIFF with YEAR interval for age calculation
  • Birth date comes second in DATEDIFF function
  • For current age, use TODAY() as reference date
Frequently Asked Questions:

Q: What if the birthday hasn't passed this year?
A: DATEDIFF calculates complete years only. It returns the age as of the reference date.

Q: Can I get months too?
A: Yes! Use DATEDIFF with MONTH interval to get total months.

9 Leap Years
Exercise 9
How do I check if 2024 is a leap year in Power BI?
Definition:

Leap year: A year that has 366 days instead of 365, with February having 29 days instead of 28.

Note: Occurs every 4 years, except for years divisible by 100 but not by 400.

Step-by-step leap year check:
  1. Try to create February 29 of that year
  2. Check if the date is valid
  3. If valid, it's a leap year; if invalid, it's not
Year
2024
Is Leap Year
Yes
Step 1: Try to create Feb 29

DATE(2024,2,29)

Step 2: Check validity

If Power BI accepts the date, 2024 is a leap year.

Step 3: Verify result

Since 2024 is divisible by 4 and not by 100, it's a leap year.

DATE(2024, 2, 29)
2024 is a leap year (February 29 exists).
Final answer:

Yes, 2024 is a leap year.

Applied rules:

• Leap year rule: Divisible by 4, except century years not divisible by 400

• Validation method: Try creating Feb 29 to test leap year

• Boolean result: Returns success/failure based on date validity

• Practice Tip: Use for date validation and calendar operations

Related Examples:
  • DATE(2024,2,29) -- Valid (returns date)
  • DATE(2023,2,29) -- Invalid (returns error)
  • DATE(2000,2,29) -- Valid (divisible by 400)
  • DATE(1900,2,29) -- Invalid (divisible by 100, not 400)
Quick Tips:
  • Remember: "Every 4 years" with century exceptions
  • Use date validation to check for leap year status
  • Century years must be divisible by 400 to be leap years
Frequently Asked Questions:

Q: Do all countries have the same leap year rules?
A: Yes, the Gregorian calendar rules are standardized worldwide.

Q: What if a holiday falls on a leap day?
A: February 29 only exists in leap years, so some holidays may shift to Feb 28 or Mar 1 in non-leap years.

10 Date Formatting
Exercise 10
How do I format a date as "March 15, 2024" in Power BI?
Definition:

Date formatting: Converting a date value to a string representation in a specific format using FORMAT function.

Note: Use format masks to specify the desired output format.

Step-by-step date formatting:
  1. Create a date value
  2. Use FORMAT function with the date and format mask
  3. Specify month, day, and year formatting
Input
FORMAT(DATE(2024,3,15))
Formatted
"March 15, 2024"
Step 1: Create date value

Use DATE(2024,3,15) to create the date.

Step 2: Format the date

Use FORMAT with "MMMM dd, yyyy" format mask.

Step 3: Use the formatted string

The result is "March 15, 2024".

FORMAT(DATE(2024, 3, 15), "MMMM dd, yyyy")
FORMAT(DATE(2024,3,15), "MMMM dd, yyyy") returns "March 15, 2024".
Final answer:

Use FORMAT(DATE(2024,3,15), "MMMM dd, yyyy") to format as "March 15, 2024".

Applied rules:

• Format mask: MMMM dd, yyyy shows full month name, day, and year

• FORMAT function: Converts date to formatted string

• Case sensitivity: Format elements must match exactly

• Practice Tip: Use different format masks for various date presentations

Related Examples:
  • FORMAT(DATE(2024,12,25), "MM/dd/yyyy") -- "12/25/2024"
  • FORMAT(DATE(2024,7,4), "dddd, MMMM d") -- "Friday, July 4"
  • FORMAT(DATE(2024,1,1), "yyyy-MM-dd") -- "2024-01-01"
Quick Tips:
  • MMMM = Full month name (March)
  • MMM = Abbreviated month (Mar)
  • MM = Month number with leading zero (03)
  • dd = Day with leading zero (15)
  • yyyy = 4-digit year (2024)
Frequently Asked Questions:

Q: What are other common format masks?
A: MM/dd/yyyy, yyyy-MM-dd, MMMM dd, yyyy, and many more.

Q: Can formatting affect date comparison?
A: No, formatting only affects the string representation. The underlying date value remains unchanged.

Detailed Summary: Comparing Datasets in Power BI

Definition: Comparing datasets in Power BI involves using DAX (Data Analysis Expressions) functions and comparison operators to determine relationships between dates. This is fundamental for data analysis workflows that need to order records, filter by date ranges, or validate date relationships.

Core Concepts:

  • DATE function: Creates date values using year, month, day parameters in DAX
    • Comparison operators: Using <, >, = for direct date comparison
  • TODAY function: Returns the current date and updates automatically
  • Date difference: Calculating duration between two dates using DATEDIFF function
  • Date formatting: Converting date values to string representations using FORMAT function

Key Rules and Laws:

  • Creation rule: Use DATE(year, month, day) with year, month, day in that order
  • Comparison rule: Earlier dates are less than later dates
    • Storage rule: Power BI stores dates as numbers for efficient comparison
  • Arithmetic rule: Date subtraction returns the number of days between dates

Step-by-Step Methods:

  1. Create Date: Use DATE(year, month, day) function
  2. Compare dates: Use operators like <, >, = between DATE values
  3. Calculate differences: Use DATEDIFF function for precise calculations
  4. Format output: Use FORMAT function with appropriate format mask

Examples (Simple to Advanced):

  • Simple: DATE(2024,1,1) -- January 1, 2024
  • Medium: DATE(2024,1,1) < DATE(2024,12,31) -- returns true
  • Advanced: DATEDIFF(TODAY(), DATE(2010,1,1), YEAR) -- calculates age in years

Tips and Tricks:

  • Memory Tip: Remember Y-M-D order for DATE function
  • Comparison Tip: Use < for "earlier than", > for "later than"
  • Validation Tip: Always verify date formats match expected pattern
  • Formatting Tip: Use FORMAT for consistent date presentations

Common Pitfalls:

  • Using wrong parameter order in DATE function
  • Confusing comparison operators (< vs >)
  • Not accounting for leap years in calculations
  • Incorrect format masks causing unexpected output

Key Notes for Memorization:

  • Remember: DATE function order is Year-Month-Day
  • Practice: Test date comparisons with known values
  • Visualize: Think of dates on a timeline from left to right
  • Connect: Relate to real calendar concepts you know
Key Laws, Methods, Rules, and Definitions
date1 < date2 → earlier
Date Comparison
Key definitions:

Comparing datasets in Power BI: Using DAX functions and comparison methods to determine which date occurs earlier or later in the calendar sequence

DATE function: A function that creates a date value using year, month, day parameters

Comparison methods: Operators like <, >, = that return boolean values

Complete methodology:
  1. Create Date: Use DATE(year, month, day) function
  2. Compare dates: Use operators like <, >, = between DATE values
  3. Calculate differences: Use DATEDIFF function for precise calculations
  4. Format output: Use FORMAT function with format mask
Tip 1: Always use DATE(year, month, day) format for date creation.
Tip 2: Use = for exact date comparison.
Tip 3: Use DATEDIFF for date difference calculations.
Tip 4: Always validate date formats match expected pattern.
Common errors: Wrong parameter order in DATE function, invalid dates, mismatched format masks.
Exam preparation: Practice DATE creation, comparison operators, and basic date calculations.
Rules to remember:

• Function order: Use DATE(year, month, day) with year first, then month, then day

• Comparison rule: Earlier dates are before later dates

• Equality rule: Use = for date comparison

• Time rule: DATE values include date components only

• Formatting rule: Use FORMAT with format mask for string representation

Rules and Methods for Comparing Datasets in Power BI
date1 < date2 → earlier
Date Comparison
DATE Function
Comparison Operators
Current Date
Date Calculations
Date Formatting

Key Takeaways

  • Use DATE(year, month, day) for date creation
  • Use <, >, = for date comparisons
  • Use DATEDIFF for date difference calculations
  • Use FORMAT for date string representation
  • Always validate date formats match expected patterns

Questions & Answers

Question: What is Power BI and why do we use it for dates?

Answer: Power BI is Microsoft's business analytics tool that excels at handling dates:

  • Easy creation: DATE(2024,3,15) creates March 15, 2024
  • Simple comparison: DATE(2024,1,1) < DATE(2024,12,31) gives true
  • Powerful features: Calculate differences, format display, validate dates
  • Reliable: Handles leap years and month lengths automatically

Power BI's date functions make working with dates safe and easy!

Example: DATE(2024,2,29) works because 2024 is a leap year.

Question: My child is in 1st grade - why are they learning Power BI?

Answer: While 1st graders don't typically learn Power BI, introducing data analysis concepts can be beneficial:

  • Logical thinking: Understanding sequences and patterns
  • Problem solving: Breaking problems into steps
  • Math connections: Data analysis reinforces math concepts
  • Future skills: Basic understanding of data visualization

However, actual Power BI would be too advanced for 1st grade. This content might be better suited for older students learning about date concepts in data analysis.

Tip: Focus on calendar skills, date sequencing, and time concepts in 1st grade, then introduce data tools later.

Question: What does DATE(2024,3,15) mean? It looks like a big word!

Answer: DATE(2024,3,15) is like a computer instruction that says "create the date March 15, 2024!" It's like a special command:

  • DATE: The function that creates the date
  • 2024: The year (like 2024 AD)
  • 3: The month (March is the 3rd month)
  • 15: The day (the 15th day)

Think of it like giving a computer exact instructions for a date: year-month-day!

Practice tip: Remember the format is YYYY-MM-DD with hyphens!

Power BI Date Glossary

DATE Function
A Power BI function that creates a date value using year, month, day parameters in DAX (Data Analysis Expressions).
TODAY Function
A Power BI function that returns the current date in Power BI.
Comparison Operator
Symbols like <, >, = used to compare values. For dates, they compare chronological order.
DATEDIFF Function
A Power BI function that calculates the difference between two dates in specified intervals (days, months, years).
FORMAT Function
A Power BI function that converts a date value to a string representation using a format mask.

Math Learning Educational Team

Certified Elementary Math Educators & Power Platform Specialists

Our team combines elementary education expertise with data analysis knowledge to create unique learning experiences that bridge traditional math concepts with modern data visualization tools. All content is designed to align with educational best practices while introducing data analysis concepts in an accessible way.

Learning Objectives

  • Understand DATE function and date creation in Power BI
  • Use comparison operators to evaluate date relationships
  • Calculate date differences using DATEDIFF function
  • Format dates using FORMAT function with format masks
  • Solve problems involving date comparisons and calculations

Power BI Date Comparison Guide

Date Creation
DATE(YYYY,MM,DD)
Year-Month-Day
Comparison Operators
📅
< > =
Compare dates
Date Operations
📅 - 📅 = 📏
DATEDIFF function
Days calculation
Earlier
DATE(2024,1,1)
<
vs
Later
DATE(2024,12,31)
Result: True
Date Value
Comparison
Power BI Date Operations
Create
Compare
Calculate
Format