Forum Discussion

Chrisss14's avatar
Chrisss14
Frequent Visitor
3 years ago

Create Dynamic Date Bookmark

Hi All,

 

I have 2 bookmarks called 'This Month' and 'Last Month'. I would like these bookmarks to be able to dynamically update with the 1st day of each month without caching if that's possible? 

 

For example, for this current month I want it to display the 1st January by default which is fine but when we enter February, I would like this to tick 1st February by default without the user having to have any input.

 

Thanks!

 

 

Need Help
Tips and Tricks

1 Reply

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    hello Chrisss14 ,

    Create a calculated column with the following measure

    Current Month = IF(FORMAT((TODAY()),"mmmm") = 'Date'[Month],"Current Month",'Date'[Month])

    If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

     

    Follow me on Linkedin