Forum Discussion
How do I get Max Timestamp for Each Day using DAX
You could use this formula to create a column
Column = CALCULATE(MAX('Table'[Datetime]),FILTER('Table',FORMAT([Datetime],"yyyy/MM/dd")=FORMAT(EARLIER([Datetime]),"yyyy/MM/dd")))or use this formula to create a measure
Measure = CALCULATE(MAX('Table'[Datetime]),FILTER(ALLSELECTED('Table'),FORMAT([Datetime],"yyyy/MM/dd")=FORMAT(SELECTEDVALUE('Table'[Datetime]),"yyyy/MM/dd")))Regards,
Lin
IF(CALCULATE(MAX(Table1[date]),ALLEXCEPT(Table1,Table1[date]))=MAX(Table1[date]),1,0)
And add this measure to visual level filter ans set it to 1.
Thanks. Tried that but couldnt get to work. Do I need to split the column into two ... date, time?
- Yes that will make it much easier.
Take out another date column out of using
date = format(table[datetime],"dd/mm/YYYY")
and then on visual take max of date time. If you want populate in table a new column then use
maxx(filter(table,table[date]=earlier(table[date])),table[datetime])
But this also needs date
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
