I'm encountering a road block, how do i get the month in a date data type?
I have a column date hired and regularization date. I want to compute for the 5, 3 and 1 month remaining before regularization.
I'm also thinking if the regularization date is on the next year of the date hired, how do i compute for the month/s remaining before regularization date?
Solved! Go to Solution.
you can use the dax formulas
Month Diff = DATEDIFF(MIN( 'View_EntryDate'[Entry Quarter] ), MAX( 'View_EntryDate'[Entry Month]), month )
If I understand your question correctly, you have a column that represents months and you can't convert this to a data type of Date.
Try making it a single day of the month (include day month and year). I suggest making it the 1st of the month.
Do you have an example of the data that won't convert?
It looks like your columns are using a DATE datatype whcih is good.
If you are just after the difference between the two dates on each row you can add a calculated column to your table along these lines. This will count the number of months between the two dates. Please let me know if this is now what you are after.
Months Between = DATEDIFF( [date_hired], [regularization_date], MONTH )
Yes, now I'm after the number of months.
I tried the formula and i'm encountering an error:
I also tried switching the regularization_date and hired_date
Months Between = DATEDIFF([date_hired],[regularization_date],MONTH)
Months Between = DATEDIFF([regularization_date],[date_hired]MONTH)
Are all months going to represent dates in the same year?
Not the dates you'll calculate but the months you have to transform into dates are they all in the same year?
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!