Power BI DAX Min Date Minus

In this Microsoft Power Bi tutorial, we will learn how to calculate Power BI Dax Min Date minus a particular period in Power BI.

In a recent Power Bi project, I had to calculate the minimum date values using the Power BI Min function, Also covered below topics:

  1. Power BI DAX min date minus 1 day
  2. Power BI DAX min date minus 1 year
  3. Power BI DAX min date minus 1 month
  4. Power BI DAX min date minus days
  5. Power BI DAX min date minus 6 months

Power BI DAX min date minus 1 day

Let us see how we can calculate the minimum date minus 1 day using the Power Bi Min function.

In this example, we will find the minimum date value of the existing car’s table date column later we will minus 1 day from the min date value.

  • Open the Power Bi desktop, and load the data into the desktop. Once the data has been loaded, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum date value.
MinDate = MIN(Cars[Released Date])

Where,

  1. MinDate= New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane.
  • In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the minimum date value as ( 12/17/2020).
Power BI DAX Min Date Minus
Example of the Power BI DAX min date

Now, in the same way, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum date value minus 1 day.

MinDate = MIN(Cars[Released Date])-1

Where,

  1. MinDate= New Measure name
  2. Cars = Table Name
  3. Released Date = Existing column name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane.
  • In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the new card visually displays the expected value as (12/16/2020) whereas, the minimum value is ( 12/17/2020).
Power BI DAX min date minus 1 day example
Power BI DAX min date minus 1-day example

This is how to calculate the minimum date minus 1 day using the Power Bi Min function.

Read Power BI DAX Min Date Validation

Power BI DAX min date minus 1 year

Let us see how we can calculate the minimum date minus 1 year using the Power Bi Min function in Power Bi,

See also  Power BI Measure If Multiple Conditions

In this example, we will find the minimum year value of the existing table date column later we will minus 1 year from the min year value.

  • Open the Power Bi desktop, and load the data into the desktop. Once the data has been loaded, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum year value.
MinYear = CALCULATE(YEAR(MIN(Cars[Released Date])))

Where,

  1. Min Year = New Measure name
  2. Cars = Table Name
  3. Released Date = Existing column name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane.
  • In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the minimum year value as (2020).
Power BI DAX min date minus 1 year
Power BI DAX min date minus 1 year

Now, in the same way, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum year value minus 1 year.

MinYearMinus1 = CALCULATE(YEAR(MIN(Cars[Released Date]))-1)

Where,

  1. MinDateMinus1 = New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane. In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the expected value as 2019 whereas the minimum year value is 2020.
Power BI DAX min date minus 1 year example
Power BI DAX min date minus 1-year example

This is how to calculate the minimum date minus 1 year using the Power Bi Min function in Power Bi.

Check Out: Power Bi Dax Today() function

Power BI DAX min date minus 1 month

Let us see how we can calculate the minimum date minus 1 month using the Power Bi Min function in Power Bi,

In this example, we will find the minimum month value of the existing table date column later we will minus 1 month from the min month value.

  • Open the Power Bi desktop, and load the data into the desktop. Once the data has been loaded, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum month value which displays the minimum date month value.
MinMonth = CALCULATE(MONTH(MIN(Cars[Released Date])))

Where,

  1. Min Month= New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane. In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the minimum month value as (12) based on the minimum date value.
Power BI DAX min date minus 1 month
Power BI DAX min date minus 1 month

Similarly, create another measured value to calculate the min date month minus 1 month using the Power Bi Min function in Power Bi.

MinMonthMinus1 = CALCULATE(MONTH(MIN(Cars[Released Date]))-1)

Where,

  1. Min MonthMinus1 = New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane. In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the expected value as 11 whereas the minimum date month value is 12.
Power BI DAX min date minus 1 month example
Power BI DAX min date minus 1-month example

This is how to calculate the minimum date minus 1 month using the Power Bi Min function in Power Bi.

See also  Power bi Dax Today() Function [With real examples]

Read Power BI DAX Min Date

Power BI DAX min date minus days

Here we will see how we can calculate the minimum date and minus x – days using the Power Bi Min function in Power Bi,

In this example, we will minus 3 days from the minimum date value using the Min function in Power BI.

  • Load the data into the Power Bi desktop. Once the data has been loaded, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum date value.
MinDate = MIN(Cars[Released Date])

Where,

  1. MinDate= New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane.
  • In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the minimum date value as ( 12/17/2020).
Example of the Power BI DAX min date
Example of the Power BI DAX min date

Now to minus x days, create a new measure and apply the below formula here we will minus 3 days from the minimum date value.

MinDateMinus3 = MIN(Cars[Released Date])-3

Where,

  1. Released Date = Existing column name
  2. MinDateMinus3 = New Measure name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane. In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the date value as 12/14/2020 by minus 3 days from the minimum date value.
Power BI DAX min date minus days
Power BI DAX min date minus days

This is how to calculate the minimum date and minus x – days using the Power Bi Min function in Power Bi.

See also  Power BI Date Slicer [11+ Examples]

Read Power BI Matrix Multiple Column

Power BI DAX min date minus 6 months

Let us see how we can minus 6 months from the minimum date value using the Power Bi Min function in Power Bi.

In this example, we will find the minimum month value of the existing table date column later we will minus 6 months from the min month value.

  • Open the Power Bi desktop, and load the data into the desktop. Once the data has been loaded, select the new measure option from the ribbon under the Home tab and apply the below-mentioned formula to find the minimum month value which displays the minimum date month value.
MinMonth = CALCULATE(MONTH(MIN(Cars[Released Date])))

Where,

  1. Min Month= New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane. In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the minimum month value as (12) based on the minimum date value.
Power BI DAX min date minus 1 month
Power BI DAX min date minus 6 months

Similarly, create another measured value to calculate the min date month minus 6 months using the Power Bi Min function in Power Bi.

MinMonthMinus6 = CALCULATE(MONTH(MIN(Cars[Released Date]))-6)

Where,

  1. Min MonthMinus6 = New Measure name
  2. Released Date = Existing column name
  3. Cars = Table Name
  4. Month = Function Name
  • Now in the report section, select the Table visual and Card Visualfrom the visualization
  • In the Table Visual, drag and drop the Car Name, Car Model, and Released date fields from the field pane. In the Card Visual, drag and drop the created measure value in it.
  • In the below screenshot, we can see that the card visually displays the expected value as 6 whereas the minimum date month value is 12.
Power BI DAX min date minus 6 months example
Power BI DAX min date minus 6 months example

This is how to minus 6 months from the minimum date value using the Power Bi Min function in Power Bi.

This Power BI tutorial explained how to easily calculate the Minimum date values from the table data and minus dates for the mentioned period. Also, we covered these topics below:

  • Power BI DAX min date minus 1 day
  • Power BI DAX min date minus 1 year
  • Power BI DAX min date minus 1 month
  • Power BI DAX min date minus days
  • Power BI DAX min date minus 6 months

You may like the following Power Bi tutorials:

>