mhireholi
11 years agoNew Member
Status:
Under Review
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-8d088b44ad...
seary
6 years agoNew 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...
Recent ideas
Enable mirroring of Google BigQuery Views
currently only tables are supported, Please enable mirroring of Google BigQuery Viewsjayantjape3 hours agoRegular VisitorNew65Views1like1CommentRestore PNG snapshot attachments in Power BI report subscriptions
Microsoft recently migrated Power BI report subscriptions to a new email delivery platform. As part of this change, report snapshots are no longer delivered as separate PNG attachments and are only e...modch6 hours agoNew MemberNew87Views10likes2Comments