Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Not getting option for time intelligence in quick measures

Hi everyone. I'm trying to figure out how to use the Quick measures options to create a Time-intelligence measure. However, unlike before I do not see a separate section for time-intelligence related...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    For your problems, according to the restrictions given in the official website document, we can't create time intelligence quick measures when working in DirectQuery mode. Therefore, if you still need the function of quick measurement, please change the connection mode of the data source.

     

    Here is the reference document link: Use quick measures for common and powerful calculations - Power BI | Microsoft Docs

    Best Regards,
    Henry

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes, I am. Although, I should mention that my Date table is in import mode only & is generated with M-script in PBI Desktop itself.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It might easily be that in DQ mode the Quick Measures feature is not available in full or in part. As I mentioned before, you could try to have your Date table in dual mode and see what happens then. By the way, all your dimensions could/should be in dual mode and the most granular fact tables should be in DQ. You should create aggregations to speed up the measures and model itself.