Forum Discussion
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
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-dateI'm not clear on how you want to merge the tables - is it with simple join?
3 Replies
- Stachu
Community Champion
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-dateI'm not clear on how you want to merge the tables - is it with simple join?
Got it, thanks
- Greg_Deckler
Perhaps something like this:
Column = IF([Years]) IN 'KeyYears'[Years],"Important","Still important but not really all that important")
