Forum Discussion
firstredpepper
8 years agoAdvocate II
Simple DAX Time Intelligence Question
Hi there, Imagine you have a dataset of three months of data with a pre-calculated column for year-to-date, YTD (you do not have the full year because it's too large). What DAX pattern would you ...
ricardocamargos
8 years agoContinued Contributor
Hi firstredpepper,
Try this function:
https://msdn.microsoft.com/en-us/library/ee634400.aspx.
Be aware you should have a continuous date column to work with time intelligence functions. It's better you create a date dimension to work with that.
Ricardo
firstredpepper
8 years agoAdvocate II
Thank you for the speedy reply Ricardo! I will try out your suggestion. : )