Forum Discussion

JulianHC's avatar
JulianHC
Regular Visitor
7 years ago

Calculated Column not updating on scheduled refresh

Hi everyone,

 

I have a report that I've published to Power BI Service which uses a Date Dim with calculated columns labelling relative time periods.

 

My scheduled refresh updates the data from my source tables, but it does not recalculate my calculated columns in my Date dim.

 

The calculated columns were created with DAX (example below)

 

Relative Month = Date_dim[SequentialMonthNumber] - CALCULATE(SUM(Date_dim[SequentialMonthNumber]),ALL(Date_dim),TODAY()=Date_dim[Date])
 
This column will give me 0 for the current month, -1 for the previous month, -2 for two months ago, etc.. when the next month comes along (May) the [Relative Month] column should label all days in May as 0. But running the scheduled refresh leaves all days in April as 0..
 
Downloading the report and republishing fixes this issue and gives me the correct recalculated columns.. but this defeats the purpose of a scheduled refresh.
 
How can I get the scheduled refresh to reload dimensions so that calculated columns are recalculated?
 
 
Thanks,
J
 
 
 
 
Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Hi there

    On every refresh all the calculated columns should be refreshed?

    What time is the refresh happening?

    I see that you are using TODAY(), and due to all the power BI servers having their dates stored in UTC it could be a timing issue?