Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper III
Helper III

dateadd from Mindate

Good Afternoon,


I am trying to create a measure to get one month less from the Min date so: 




But im getting not correct type for the Min(hire[start_date]) section.


How do i correct this? 


Thank you 

Community Support
Community Support

Hi @sovereignauto ,


What do you expect this code to return? 


DATEADD returns a table with a set of dates. And the first parameter is the entity column
The full formula is what MIN(hire[start_date]) may return here is the minimum value of [start_date] in the current filtering context.


If you expect to return a date, try the EDATE function.

 try like:

= EDATE(MIN('hire'[start_date]),-1)

or the smallest of all dates:

= EDATE(CALCULATE(MIN('hire'[start_date]),ALL()),-1)


Best Regards,

Community Support Team


If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Community Champion
Community Champion

Do you have a date table?

do you need the result of the measure to be an actual date?

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Yes i have a Datetable


the result of the measure would end up being 90% of a count of hire starts from the previous month 

Community Champion
Community Champion

What is the Min date supposed to be calculating?

What is the structure of the data?

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

So i have a table of hire start dates (with other information) 


and im dropping months into the columns of a Matrix 

So what i want to do is get the Min of the column (so basically start of that given month) and then minus 1 month from that. 

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.