Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Setting a default date

Hi,

 

I have a table with columns:

statusdate, CustomerNo, Price

 

In my report i have slicer statusdate and a table with CustomerNo, Price

 

The slicer has between date

I want to default the slicer date to last Friday as the end date and 4 months from today as the start date as an example.

Example: for today's date (9/10/2020)

 

 

This has to happen every time we open the report.

Please let me know if there is a dax code i can use.

 

 

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous So sometimes you would do this by creating a column that calculates to something like "Last Friday" and "Not Last Friday" but Not sure this will work on range. maybe a relative date slicer? 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , I doubt there something can be done for a range , you can create some filter like this a control the complete range

     

    This example for month , you have get Range of your choice

    Month Type = Switch( True(),
    eomonth(Date[Date],0) = eomonth(Today(),0) ,"Current Month" , //This Month
    eomonth(Date[Date],0) < eomonth(Today(),0) && ,"Previous Month" , //last Month
    eomonth(Date[Date],0) > eomonth(Today(),0) && ,"Next Month" , //last Month
    [Month Year]
    )