cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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]) )
Highlighted
New Member

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]) )
Highlighted
Advocate I
Advocate I

Re: Time intelligence does not work

I have the same issue. Any news?

Highlighted
Advocate III
Advocate III

Re: Time intelligence does not work

Sorry for a late response. 

 

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

 

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

Highlighted
New Member

Re: Time intelligence does not work

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

 

Thank you.

 

Highlighted
Advocate III
Advocate III

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

Highlighted
Regular Visitor

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]
    )
 
 
Highlighted
Anonymous
Not applicable

Re: Time intelligence does not work

For anyone still encountering this issue, this fix worked for me. In retrospect this is probably quite obvious to the experienced users here, but for those of us still learning it isn't quite so clear.

 

Assuming you have created a custom date dimension, right click on the table name in your fields list. Navigate down to "Mark as date table" and make sure it is checked. Now I no longer recieve the error at the top of the thread.

Highlighted
New Member

Re: Time intelligence does not work

I had the same error others had, and the following auto generated code worked fine for me, after I *cleared my filters* of time-based criteria.  
 
 
_INDY rolling average 2 =
IF(
    ISFILTERED('Daily Kit Count - RCV'[_ WeekEnding]),
    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
    VAR __LAST_DATE = LASTDATE('Daily Kit Count - RCV'[_ WeekEnding].[Date])
    RETURN
        SUMX(
            DATESBETWEEN(
                'Daily Kit Count - RCV'[_ WeekEnding].[Date],
                DATEADD(__LAST_DATE, -1, DAY),
                __LAST_DATE
            ),
            CALCULATE(SUM('Daily Kit Count - RCV'[_INDY]))
        )
)

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors