Forum Discussion
CJANE
9 years agoHelper I
Default Date on Report
I have a report that displays total market value for a list of accounts. The report supports the ability to select a date to see current or historical market values based on date selected in slicer....
JordanAWARE
9 years agoFrequent Visitor
Hey is it possible to get a screenshot to see how the date/historical data is setup?
Or in your historical calculations you could try add an is filtered:
if ( ISFILTERED('Date'[date],
calculate stuff with filtereddate,
calculate stuff to show with no date filters)
Not sure if something like this will work with your calculations but it is specifiying what to calculate when there is no date filter - which is where you would just calculate your 'default' date