Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

DatesInPeriod () function accepts it's first parameter as "Date" only with default 12:00:00AM timestamp. What about for different time?

https://social.technet.microsoft.com/Forums/en-US/b6ccbaf4-cd8d-4bb7-993c-8d088b44adf8/disconnected-slicer-in-powerview-hour-day-week-month-year-max?forum=powerview#b6ccbaf4-cd8d-4bb7-993c-8d088b44adf8
Status: Under Review
Comments
nishalit
New Member
Thanks for the suggestion Manjunath. Who else would find this useful? Please add your vote if you think it is!
manjunath_hireh
New Member
http://stackoverflow.com/questions/27498880/minute-hour-day-week-month-year-filter-for-power-view-charts-in-powe?answertab=active#tab-top looking for Minute Hour Day Week Month Year Max Filters in Power View charts.
manjunath_hireh
New Member
This is a very useful feature that allows users to drill down to Hour, Minute and seconds level to see what's happening with the data. Please add this at the earliest. Thanks.
seary
New Member
I think it would be useful to me if you not only allowed datesInPeriod to accept timeStamp values but also allowed the interval parameter to support "hour" resolution. Right now, I think the best resolution available is "day". I have a situation where I am computing the the number of times something happened in the last few hours. camargos88 gave me some DAX that worked, but I think it's broke now and it's not entirely intuitive to read. Enhancing the DatesInPeriod function to work with hours might make the DAX more readable and easier to maintain: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Sum-of-Failures-Last-Hour/td-p/1037662 The above forum post is a fictional example of a real problem I am dealing with. It's actually far easier to compute the Sum of Failures (within the last few hours) using a language other than DAX, but DAX is what Power BI offers...
fbcideas_migusr
New Member
Status changed to: Under Review