Significant anniversaries

[RichardS]

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

[Greg_Deckler]

Perhaps something like this:

Column = IF([Years]) IN 'KeyYears'[Years],"Important","Still important but not really all that important")

[Stachu · Accepted solution]

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?

[RichardS]

Got it, thanks