Reply
Frequent Visitor
Posts: 4
Registered: ‎01-03-2019

Re: Time intelligence does not work

Hi @jayanthan, Do you mean the below? Appreciate your help... Sales _Volume YTD = IF( ISFILTERED('tbl_Sales'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), TOTALYTD(SUM('tbl_Sales'[Sales _Volume]), 'tbl_Sales'[Date].[Date]) )
Frequent Visitor
Posts: 4
Registered: ‎01-03-2019

Re: Time intelligence does not work

Hi @aviral, Appreciate your help, i can't post a screenshot as it won't let me but i did format as a date and also ensured that the locale was also on the correct setting. Please see below for code. Sales _Volume YTD = IF( ISFILTERED('tbl_Sales'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), TOTALYTD(SUM('tbl_Sales'[Sales _Volume]), 'tbl_Sales'[Date].[Date]) )
Frequent Visitor
Posts: 2
Registered: ‎12-17-2018

Re: Time intelligence does not work

I have the same issue. Any news?

Regular Visitor
Posts: 33
Registered: ‎05-17-2016

Re: Time intelligence does not work

[ Edited ]

Sorry for a late response. 

 

Make sure in the settings "Time Intelligence" is ticked as shown below. 

 

2019-01-24_10-49-32.png

Frequent Visitor
Posts: 4
Registered: ‎01-03-2019

Re: Time intelligence does not work

Sorry i can't see the image- can you explain please?

 

Thank you.

 

Regular Visitor
Posts: 33
Registered: ‎05-17-2016

Re: Time intelligence does not work

Have updated the image.

 

You will have to go into File->Options and Settings->Options->Current File->Data Load

Frequent Visitor
Posts: 3
Registered: ‎01-17-2018

Re: Time intelligence does not work

Hi

I have the same issue but in a measure.  My time intelligence button is ticked.

Do you have any suggestions? I have been spending the last 3 days trying to get the year to date formula working but it is just not happening.

Many thanks!! 

 

Estimated Annualised Savings 2018 YTD =
IF(
    ISFILTERED('Date'[Date].[Date]),
    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
    TOTALYTD(
        [Estimated Annualised Savings 2018],
        'Current Month'[Date].[Date]
    )