Skip to main content

    Power BI

    Completed

    Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

    Vote (2101) Share
    Riccardo Muti's profile image

    Riccardo Muti on 13 Nov 2014 09:53:55

    If I have a date/time field in my data, I should be able to view metrics by year, by month, by day, by day of week, by time of day, and so on. I should be able to drill from month down to day, back up to month, and so on.

    I should also be able to ask for 'last 7 days' or '12 months ago' in my formulas, filters etc.

    I shouldn't need to create a "Date" table and all of these fields in my data. As long as I have a date/time field in my data, I should be able to do this analysis easily in the Power BI report (or Q&A).

    Administrator on 11 May 2017 06:45:53

    In the May release of Power BI Desktop we shipped a preview of the relative date slicer. To learn more check out this blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/ In addition, the new Quick Measures feature has a bunch of time intelligence calculations that you can add to your model. Learn more about that feature here: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/

    Comments (112)
    Riccardo Muti's profile image Profile Picture

    Jason Virtue on 05 Jul 2020 21:57:04

    RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

    Adding a date table is one great step forward. We should also automatically generate time intelligence fields to allow us to provide MTD, QTD, YoY, MoM, SDLW metrics. This would prevent most users from struggling with DAX to setup comparison reports. Based on POCs, this is one showstopper when comparing us to the competition.

    Riccardo Muti's profile image Profile Picture

    Rui Quintino on 05 Jul 2020 21:56:58

    RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

    could not agree more :) I think its time to end this constant need for date tables, even most power users don't get it... (ex: native pivot tables or see SmartCharts app for Excel, or our R/D addin for excel DataInsights )

    https://store.office.com/smartcharts-for-excel-multi-user-site-license-WA104356536.aspx?assetid=WA104356536

    http://rquintino.wordpress.com/2013/03/18/an-alternative-model-for-faster-excel-self-service-biexcel-data-insights-addon-part-i/