Forum Discussion
Solved
DAX LastDate Help
I have a dataset table that has multiple columns, however, one column is titled "runtime" which contains a date like: 6/14/2017 11:13:52 AM All of the rows in that table have the same date/...
My bad. You'd need to remove .[Date] part.
To get date portion only try using.
=DATEVALUE(MAX('2017FinancialData'[Runtime]))
EDIT: LASTDATE function works much the same way.
Try...
Updated = MAX('2017FinancialData'[Runtime].[Date])
Same result....;-(
My bad. You'd need to remove .[Date] part.
To get date portion only try using.
=DATEVALUE(MAX('2017FinancialData'[Runtime]))
EDIT: LASTDATE function works much the same way.
Perfect. Thank you!