cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

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

5 REPLIES 5
Community Support

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,
Gao

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

Do you have a date table?

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Helper III

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

What is the Min date supposed to be calculating?

What is the structure of the data?

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Helper III

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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors