I have a dashboard where I included all my cubes as data sources.
I run the command in a layout calculation to get the parameter of the update date of the cube.
CubeDataUpdatedOn[cube item]
What I want to do is to conditionally format the update date to show delays.
I have tried
cast
add_days
cast(substring(caption[cube item] #, #, integer
Anyone have any luck comparing the CubeDataUpdatedOn[cube item] to current date?
Thanks
Much easier:
_days_between (date2timestamp (Today()), CubeDataUpdatedOn ('[Cube]'))
Returns an integer with the number of days between Today and CubeUpdated date