Forum Discussion
Power Query Date.AddMonths not working
Hi, I'm struggling to make a date table which includes a column that has the date 6 months before. I did it in Dax, but for the measures that follow after I need to make a comparison which isn...
Hi Anonymous
That fx button is to invoke a custom function that you've already written, not to call inbuilt functions.
To deduct 6 months from your date column just click the Custom Column button
and add this in the code box
Regards
Phil
Anonymous , I tried on Direct Query
Date.AddMonths(DateTime.Date([Date]),-1) is not supported in Direct Query
But I was able to do Date.AddMonths([Sales Date],-1) //but my date to not have time
Hi amitchandak Thank you for your help. I don't think it will work in directquery. I've made a new date table to which I could add it.