Forum Discussion

debenaire's avatar
debenaire
Icon for Helper I rankHelper I
2 years ago

Time Travel Reporting?

Hi, I am storing data which timestamps any changes to records and inserts them into a table as a new record. As such there will be duplicate IDs but with slightly different data where there have been...
debenaire's avatar
debenaire
Icon for Helper I rankHelper I
2 years ago

thanks but what we need is the slicer to have every possible day even if that day is not the exact same create date, the logic will choose the first date equal to or less than the slicer date for each id

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi debenaire ,

You can create a New table:

Table = CALENDAR(DATE(2000,1,1),NOW())

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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