Forum Discussion
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[star...
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