How to Add or Subtract Dates from a count of dates value?

[mdrammeh]

Hello,

I am looking for assistance on how to solve the following functon in both Power BI and Power Query.

Thank you!

[v-ljerr-msft · Accepted solution]

Hi @mdrammeh,

Based on my test, your formula should work in Query Editor, Custom Column under Add Column tab.

Regards

[mdrammeh]

Thanks for answering my question!

[Greg_Deckler]

You are trying to use Power Query "M" functions in DAX. You can't do that.

You want to use functions from here:

https://msdn.microsoft.com/en-us/library/ee634396.aspx

Specifically, probably the DATEADD function or something like it:

https://msdn.microsoft.com/en-us/library/ee634905.aspx

Refer to my blog article here on the Languages of Power BI

https://community.powerbi.com/t5/Community-Blog/The-Languages-of-Power-BI/ba-p/69104