Forum Discussion
Solved
Get date from datetime column, source is live connection
I'm trying to compare the current date against a column that is formatted as a datetime column in the source PBI dataset. I've re-set the Format from a datetime format to just yyyy-MM-dd in the repor...
Using DATEVALUE() on the datetime column seems to have gotten me the correct output.
Column = DATEVALUE('Project'[X_DATE_CLOSED]) = DATEVALUE("2024-08-27")
Using DATEVALUE() on the datetime column seems to have gotten me the correct output.
Column = DATEVALUE('Project'[X_DATE_CLOSED]) = DATEVALUE("2024-08-27")