Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
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
Do you have a date table?
do you need the result of the measure to be an actual date?
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
What is the Min date supposed to be calculating?
What is the structure of the data?
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
125 | |
108 | |
60 | |
55 |