mercredi 22 janvier 2020

Get output within multiple date ranges (and if statements) in Power Query

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