Hi Everyone,
How do I subtract Months(which is in column) from a Date Column.
Results needs to be in months as well as date if possible.
Columns are as atttached.
Thank you!
If it is a calculated column using DAX have you tried using EDATE?
Yes I have tried that, but edate dosen,t takes column as input which here would Terms column
There is also a dateadd function I think that takes columns?
Edit, if its a column you are putting in your model, you could use date.add.months or something similar to that in power query
date.addmonths function works in Power Query.
Thanks for your input
1 Like
Just following up if you still require assistance to solve your inquiry.
If the inquiry is solved, do not forget to close this thread by tagging the reply as the Solution
Its working… Thank you