Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
IAM
Helper III
Helper III

Calculated column for "Today" is not updating in Power BI Service

Hi all,

 

I have a calculated column to give a mark if a line is due on 'today' and I have that filter on in a table. So, on March first I uploaded the file to Service and I saw the jobs that were due on March first.

 

Today it is March third and I still see the jobs from March first. I refreshed the report and the dataset, but nothing is changing. When I open the Power BI file, it jumps to March 3th immediately. 

 

Is it a bug, or am I doing something wrong? Thanks!

1 ACCEPTED SOLUTION
pacoduabe
Regular Visitor

Since it's a calculated column it won't calculate again today's date until it's refreshed. It should work fine if you refresh the dataset and wait until it completes. In any case, you can set a measure to do this filter, such as:

 

INT ( 'Table'[Date] >= TODAY() )

 

You need to use INT in order to apply the filter (it would return 1 if true and 0 if false), you can use the previous measure as a visual filter. It won't let you add it to a filter box object. Hope this helps you anyhow.

View solution in original post

1 REPLY 1
pacoduabe
Regular Visitor

Since it's a calculated column it won't calculate again today's date until it's refreshed. It should work fine if you refresh the dataset and wait until it completes. In any case, you can set a measure to do this filter, such as:

 

INT ( 'Table'[Date] >= TODAY() )

 

You need to use INT in order to apply the filter (it would return 1 if true and 0 if false), you can use the previous measure as a visual filter. It won't let you add it to a filter box object. Hope this helps you anyhow.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors