Using Date formulas in power Query (1D, 2W, etc)

Hi Gringohekus ,

You could add a custom column something like this:

Payment_Terms_Days =
if Text.Contains([Payment_Terms_Link.Due_Date_...], "W")
then Number.From(Text.Select([Payment_Terms_Link.Due_Date_...], {"0".."9"})) * 7
else Number.From(Text.Select([Payment_Terms_Link.Due_Date_...], {"0".."9"})

This should give you a column that converts your 30D/2W column into number of days that you can use for further date calculations. It's also easy enough to see the formula structure I've used if you wanted to add conditions for 'M' or 'Y' etc.

I get the following output:

Pete