power query M函数

常见备忘

#多重条件

each if [订单状态] = "取消" and [支付时间] <> "null" then "退款"
else if [订单状态] = "" and [支付时间] = "null" then "取消"
else "有效订单"

if [剪辑] = "其他" 
and [编导] = "其他" 
and [拍摄] = "其他" 
and [运营] = "其他"
and [运营] = "其他"
then "无效" else "有效"

#日期标签

条件：满足足条件位设定上月日期标签为“上月”，上上月日期标签为“上上月”

if Date.Month([时间]) = Date.Month(Date.AddMonths(DateTime.LocalNow(),-1)) then "上月"
else if Date.Month([时间]) = Date.Month(Date.AddMonths(DateTime.LocalNow(), -2)) then "上上月"
else "过往"

注意if大小写

若是本月的话

if Date.Month([时间]) = Date.Month(DateTime.LocalNow()) then "本月"
else if Date.Month([时间]) = Date.Month(Date.AddMonths(DateTime.LocalNow(), -1)) then "上月"
else "过往"