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

Today Function in Column

A weird issue has come up, and I'm not sure if this is an issue with how I created a field, or how the data is refreshing. 

 

We have created an inventory forecast which uses data from multiple sources - inventory and orders from an internal data warehouse, planned production from an excel file.  Because there are multiple sources, the data is imported, rather than continuously updated. 

 

Not everything in inventory is currently available - some is undergoing testing and will be available at a later date.  So I created a calculated column, a date field, which is set to today if the inventory is available, and to whatever its assumed testing release date is if it is not.  

Inventory Available Date =  If([Post Testing Date] < today(), today(), [Post Testing Date])

 

The visualization that shows the forecast is filtered for the next 13 months, starting from today.  We have a reference date table - that date table and the inventory table are linked by [Inventory Available Date]

 

The problem is that the [Inventory Available Date] does not update in the published version.  So if the data was refreshed yesterday, when I open the report today, for all records the field value is 2/10/19, even though today is 2/11/19.  The visualization, however, knows the correct date, and so none of the current inventory is showing up in the table, since those values are yesterday. 

 

With the desktop version - if I leave it open overnight and come in the next morning, the issue is the same - as soon as I click on something, change a filter, etc, the value for [Inventory Available Date] updates correctly.  But for the web/published version, changing filters makes no difference. 

 

Our current solution is to refresh the data daily, but this seems like an odd issue, and I'm wondering if there is something in how the column is coded, or if there is something in the published version that could fix this issue.  Any thoughts are welcome!

 

Cheers!

 

3 REPLIES 3
Super User
Super User

Re: Today Function in Column

Values in DAX columns are only calculated as part of the data import.  They are not recalculated on the fly.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Community Support Team
Community Support Team

Re: Today Function in Column

Hi @smcdougal,

 

Here I suggest to configure schedule refresh of your report. And you can set the refresh time in the early morning everyday.

 

Regards,

Frank

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Today Function in Column

Hi @smcdougal ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.