Create Dynamic Date Bookmark

[Chrisss14]

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!

[Idrissshatila]

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