Hi all.
I created a report inside one dashboard and want to start everyday with today as the select date.
Hi Ricardo,
Use Aggregate({[Time].[Day].CurrentDateMember}) to create a custom calculated member in the Time Dimension. Then select that in pages and it’ll activate in the drop down filter.
When you choose that from the drop down it’ll always have the current day. Hope this helps.
– Malik Graves-Pryor
1 Like
Thanks malikgp. Is it possible to start the report with this value?
Yep, when you save the report with the value selected in the dropdown it will start the report with that value.
If you change the dropdown to a different value and then save it then the report will execute with that new saved value.
Hope this helps.
– Malik Graves-Pryor
1 Like