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
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
Thank you! This worked for my Date table. Not for the original DirectQuery table. But I'll just add a relationship to it then 🙂