Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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/
Proud to be a Super User!
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
Interesting behaviour,
Try this:
Proud to be a Super User!
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |