Forum Discussion
Solved
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 1...
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?
Greg_Deckler
Community Champion
Community ChampionPerhaps something like this:
Column = IF([Years]) IN 'KeyYears'[Years],"Important","Still important but not really all that important")