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 gro...
Show and Tell
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