Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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/time. I'm trying to create a new measure to show the last runtime of the file that was imported. When I try this I get the last day of the year:
Updated = LASTDATE('2017FinancialData'[Runtime].[Date])
I'm obvioulsy not using that function correctly; however, any ideas on the best approach to get it?
Solved! Go to Solution.
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 25 |
| User | Count |
|---|---|
| 124 | |
| 87 | |
| 70 | |
| 66 | |
| 65 |