- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Significant anniversaries
I am new to the Board so if this has been covered elsewhere, apologies.....
I am trying to get a report to show upcoming anniversaries of service, flagging specifically significant ones such as 10th, 21st, 25th etc. I can get the upcoming anniversaries using a date column from Excel and calculating in a table using DAX the number of years passed. I have added a table of the "key" years but I cannot think how to link that to the years calculated in the table. My alternative was to calculate the number of years in the query but I cannot see an equivalent to the DAX "TODAY()" function. Please can anyone help?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the M funcitons that may help you are:
https://msdn.microsoft.com/en-us/query-bi/m/datetime-localnow
https://msdn.microsoft.com/en-us/query-bi/m/datetime-fixedlocalnow
they return DateTime type so you may want to convert it to Date type
https://msdn.microsoft.com/en-us/query-bi/m/datetime-date
I'm not clear on how you want to merge the tables - is it with simple join?
Thank you for the kudos 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps something like this:
Column = IF([Years]) IN 'KeyYears'[Years],"Important","Still important but not really all that important")
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the M funcitons that may help you are:
https://msdn.microsoft.com/en-us/query-bi/m/datetime-localnow
https://msdn.microsoft.com/en-us/query-bi/m/datetime-fixedlocalnow
they return DateTime type so you may want to convert it to Date type
https://msdn.microsoft.com/en-us/query-bi/m/datetime-date
I'm not clear on how you want to merge the tables - is it with simple join?
Thank you for the kudos 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Got it, thanks

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-26-2023 07:31 AM | |||
Anonymous
| 10-16-2016 01:17 AM | ||
01-12-2022 02:59 AM | |||
12-02-2020 08:51 PM | |||
04-28-2022 05:43 AM |
User | Count |
---|---|
136 | |
107 | |
86 | |
58 | |
46 |