id date hour
1 Mon, 13 Mar 2023 23:59:41
2 Mon, 14 Mar 2023 22:51:40
3 Mon, 15 Mar 2023 21:52:20
If I use above measure it gives me the max date. above is my table and i want to add measure in that table and display hour. how can I achieve that?
Time Measure = VAR __DateTime = MAX('Table'[DateTime]) VAR __Result = __DateTime - TRUNC(__DateTime) RETURN __Result
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.