Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Default Date

I have Calculated Dates filter and slicers and It is perfectly working fine. I even added a TODAY filter that only filters based on today's data.   But the problem is that whenever i open the repo...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous 

    @Noor_Rahmeh , There is no way to default. You need to create a flag(new column) like this in the date table and use that as filter

     

    Is This Year = if('Date'[Date]>=date(Year(TODAY()),1,1) && 'Date'[Date]<=TODAY(),"This year",[Date]&"")

     

    check : https://youtu.be/hfn05preQYA

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous 

@Noor_Rahmeh , There is no way to default. You need to create a flag(new column) like this in the date table and use that as filter

 

Is This Year = if('Date'[Date]>=date(Year(TODAY()),1,1) && 'Date'[Date]<=TODAY(),"This year",[Date]&"")

 

check : https://youtu.be/hfn05preQYA