Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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?
Perhaps something like this:
Column = IF([Years]) IN 'KeyYears'[Years],"Important","Still important but not really all that important")
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?
Got it, thanks