How to separate time from the date column in a live connection

[Nick310]

Hello Everyone,

I am finding it difficult to separate the time/hours from the date column as shown in the attached image. I just want to see the date only. I don't have access to the data sets, it's a live connection.

Is there anyway I can use Dax to do this? I will be happy to read your solutions. Thanks in advance.

 

[ValtteriN]

Hi,

The most straightforward measure would be something like this:

MAX(Table[Date]) 

Note the format here ^^


End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Nick310]

Hello ValtteriN,

Thank you very much for your kind suggestion!

I just followed your procedure, but I didn't get the expected results. Please check attached images for more information. Is there any other thing I am not doing correctly?

Regards

 

 

[ValtteriN]

Interesting behaviour,

Try this:

Measure 21 =

var _cdate = MAX('Calendar example'[Date])

var _date = DATE(YEAR(_cdate),MONTH(_cdate),DAY(_cdate)) return

_date