Forum Discussion
MPetramalo214
Helper I
Helper IRelative Date Slicer to Exclude Today
Hi all, On one of my reports, I have a relative date slicer for end users to view historical data. Our data syncs one day in arear though (4/13 we load 4/12 data and so on). So by default ...
Hi MPetramalo214 ,
Suppose there is a [Date] column in data table, and may be you can create a calculated column:
New Date=IF([Date]=Today(), BLANK(), [Date])Then, add this [New Date] column to visual level filter or page level filter, set it fiter syntax to "is in this month".
MPetramalo214 -> Please hit the thumbs up & mark it as a solution if it helps you. Thanks.
truptis
Community Champion
Community ChampionHi MPetramalo214 ,
Suppose there is a [Date] column in data table, and may be you can create a calculated column:
New Date=IF([Date]=Today(), BLANK(), [Date])
Then, add this [New Date] column to visual level filter or page level filter, set it fiter syntax to "is in this month".
MPetramalo214 -> Please hit the thumbs up & mark it as a solution if it helps you. Thanks.