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

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

Reply
sovereignauto
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: 

 

dateadd(MIN(hire[start_date]),-1,MONTH) 

 

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

 

How do i correct this? 

 

Thank you 

5 REPLIES 5
v-cgao-msft
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,
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

PaulDBrown
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 

PaulDBrown
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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.