Show current date as well as rolling dates on a straight table

[Anonymous]

Hi Guys

I know that the Function Today() generates the current days date.

How do I generate on a straight table the subsequent days across rows as per below so that regardless of when I open the dashboard, the current date will reflect and not be static

For eg. 21/05/2018...... 22/05/2018......23/05/2018...........24/05/2018..........25/052018

[sunny_talwar]

You do have these dates in your dashboard, right? If you do... you can use set analysis to show the data range in the object you are looking to show these in.

[Anonymous]

Hi Sunny

Yes these dates were already generated as a CalDate field up until 31/12/2018 so that the individual dates could show in a straight table.

The challenge is now displaying or updating this table to always reflect the current date and the subsequent dates that follows?

[sunny_talwar]

May be use this kind of set analysis in your expression

{<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>}

[Anonymous]

Possibly correct however it says Garbage after expression '='

[sunny_talwar]

What is the exact expression you used?

[Anonymous]

{<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>}

The one you provided

[sunny_talwar · Accepted solution]

But I told you to use this in your expression...

Sum({<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>} Measure)