Forum Discussion

Griggers's avatar
Griggers
Frequent Visitor
5 years ago

Quick Measure Rolling Average

Hi,

 

I have created a rolling average quick measure.

 

Im getting this message and really dont understand what needs to be done to rectify it -

"Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."

 

I have a date table that I generate in SQL but this is not marked as a Date Table. For time intelligence features in PBI do I need a table marked as a Date Table ?

 

Grateful for any assistance.

Griggers

Show and Tell

3 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Griggers 

     

    I found the explaination in docement.

    Here are the points to note:

    • You can use your own custom date tables with time intelligence quick measures. If you're using an external tabular model, make sure that when the model was built, the primary date column in the table was marked as a date table, as described in Specify Mark as Date Table for use with time-intelligence. If you're importing your own date table, make sure to mark it as a date table, as described in Set and use date tables in Power BI Desktop.
    • You can't create time intelligence quick measures when working in DirectQuery mode. The DAX functions used in these quick measures have performance implications when translated into the T-SQL statements that are sent to your data source.

    Reference: Use quick measures for common and powerful calculations - Power BI | Microsoft Docs

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • Griggers's avatar
      Griggers
      Frequent Visitor
      5 years ago

      Hi Janey,

       

      I have tried what has been suggested abaive, and still getthe same error.

       

      All my datasets are import mode. Any suggestions ?

       

      Thanks

      Mark

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        5 years ago

        Hi, Griggers 

         

        Can you share some fake sample data and more information about how you do it? Otherwise, it’s hard to judge the specific reason.

         

        Best Regards

        Janey Guo