Power BI DAX Min Date Validation

In the Power Bi tutorial, we will learn how to find the min date value and validate using the Power Bi DAX function in power bi.

In a recent Power Bi report, I had to calculate the min date values and validate the values and return the true or false value in a new column. Also covered below mentioned topics:

1. Power BI DAX min date validation
2. Power BI DAX min date validation in month
3. Power BI DAX min date validation for today
4. Power BI DAX min date validation two columns
5. Power BI DAX min date value validation

Power BI DAX min date validation

Let us see how we can find the min date value and validates the minimum value using the Power Bi Min function in Power Bi.

In this example, we are going to use the car’s table data to calculate the minimum date value, if the car released date is equal to the minimum date value then it displays the true value or else a false value.

• Open the Power Bi desktop, and load the data into the desktop using the get data option. Select the new column option and apply the below-mentioned formula.

Validation = 
IF ( Cars[Released Date]= MIN ( Cars[Released Date] ),TRUE(),FALSE())

Where,

1. Validation = New Column name
2. Cars = Table Name
3. Released Date = Existing Column Name

• In the below screenshot, we can see that the new column displays the minimum date value as True value else False value.

This is how to find the min date value and validate the minimum value using the Power Bi Min function in Power Bi.

Power BI DAX min date validation in month

Let us see how we can find the min date validation in a month using the Power bi DAX function in Power Bi.

In this example, we will first calculate the current month value and later we will compare the released date column month value with the current month value.

• Open the Power Bi desktop, and load the data into the desktop using the get data option. Select the new column option and apply the below-mentioned formula to find the current month’s value.

CurrentMonth = MONTH(TODAY())

Where,

1. current month = New Column Name
2. Month and Today = Function Name

In the below screenshot, you can see that the new column displays the current Month Value as 1 (the current month is January)

• In the same way, we will create a new column to validate the released date column month value number with the current month value.
• In the column formula bar, enter the below-mentioned formula:

Month Validation = IF(Cars[Released Date].[MonthNo]=Cars[CurrentMonth],"Valid","InValid")

Where,

1. Month Validation = New Column Name
2. Cars = Table Name
3. Released Date, Current Month = Existing column name

In the below screenshot, you can see that the new column displays the valid value for the matching month values else it displays the invalid value.

This is how to find the min date validation in a month using the Power bi DAX function in Power Bi.

Read Power BI Slicer Multiple Columns

Power BI DAX min date validation for today

Let us see how we can find the min date and validate it with today’s date using the Power Bi Dax min function in Power Bi.

In this example, we will calculate the min date value and validate it with today’s date. If the min date matches with today’s date it displays the valid option else it displays the invalid option.

• Load the data into the Power Bi desktop using the get data option. Select the new column option and apply the below-mentioned formula to find today’s date.

Today's Date = TODAY()

Where,

1. Today’s Date = New Column Name
2. Today = Function Name

In the below screenshot, you can see that today’s date column displays today’s date value which is 1/17/2023.

• In the same way, we will create a new column to validate the released date column month value number with the current month value.
• In the column formula bar, enter the below-mentioned formula:

Valid/Invalid = IF(Min(Cars[Released Date])= Cars[Today's Date],"Valid","InValid")

Where,

1. Valid/Invalid = New Column Name
2. Cars = Table Name
3. Released Date = Existing column name

In the below screenshot, you can see that the new column displays the invalid value because the minimum released date value doesn’t match today’s date value.

This is how to find the min date and validate it with today’s date using the Power Bi Dax min function in Power Bi.

Check Out: Power BI DAX Max Date [With 15+ Real Examples]

Power BI DAX min date validation two columns

Let us see how we can find the min date validation between two columns using the Power Bi Dax function in Power Bi.

In this example, we will find the min date value for the two different columns in Power Bi. If the released date min value is greater than or equal to the planned sale date min value then it validates and displays the value based on the applied condition.

• Load the data into the Power Bi desktop using the get data option. Select the new column option and apply the below-mentioned formula.

Valid/Invalid = var min1 = MIN(Cars[Released Date]) 
var min2 =MIN(Cars[Planned Sale Date]) return IF(min1>=min2,"valid","invalid")

Where,

1. Valid/Invalid = New Column Name
2. Cars = Table Name
3. Released Date & Planned Sale Date = Existing column name
4. min1 and min2 = Variable Names

• The Min1 variable contains the minimum date value of the released date column, and Min2 Variable contains the minimum date value of the planned sale date. If the Min1 value is greater than or equal to the min2 value then it displays the result as valid else invalid.
• In the below screenshot, you can see that the new column displays the value based on the applied condition.

This is how to find the min date validation between two columns using the Power Bi Dax function in Power Bi.

Read Power BI Create Table From Another Table

Power BI DAX min date value validation

Let us see how we can find the min date value and validates the minimum value using the Power Bi Min function in Power Bi.

In this example, we will calculate the minimum date value, if the car released date is equal to the minimum date value then it validates and return the value as valid else invalid

• Open the Power Bi desktop, and load the data into the desktop using the get data option. Select the new column option and apply the below-mentioned formula.

Value Validation = 
IF ( Cars[Released Date]= MIN ( Cars[Released Date] ),"Valid","InValid")

Where,

1. Value Validation = New Column name
2. Cars = Table Name
3. Released Date = Existing Column Name

• In the below screenshot, we can see that the new column displays the minimum date value as valid else invalid.

This is how to find the min date value and validate the minimum value using the Power Bi Min function in Power Bi.

This Power Bi tutorial helps to find the minimum date value and validates the value using the Power Bi Dax function in Power Bi.

• Power BI DAX min date validation
• Power BI DAX min date validation in month
• Power BI DAX min date validation for today
• Power BI DAX min date validation two columns
• Power BI DAX min date value validation

You may like the following Power BI tutorials:

• Power BI DAX Min Date
• Power BI Sum Group by
• Power BI Compares Two Columns in Different Tables
• Power BI Add Calculated Column
• Power BI filter between two dates
• Power BI DAX Min Date Minus