Solved: Re: Calculated column for "Today" is not updating ...

IAM · ‎03-03-2023

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!

pacoduabe · ‎03-03-2023

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

pacoduabe · ‎03-03-2023

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.