I'm trying to add a custom column in Power Query to output a price for specific date ranges. Tried the following M code but I get an error instead:
if [Date]<#date(08/12/2019) then "11.50" else if [Date]>#date(08/11/2019) and [Date]<#date(10/14/2019) then "0.00" else if [Date]>#date(10/13/2019) and [Date]<#date(12/30/2019) then "11.50" else "2.50")
Aucun commentaire:
Enregistrer un commentaire