Card更改背影色: IF 单条件判断

• 设定一下目标值-tgtAR_balance：这里是手工输入唯一值。

AR_ColorPanel1 = IF(CALCULATE(SUM((BO_AR_aging[AR_LC])))>[tgtAR_balance],"#FA8072","#7CFC00")

• 将设定的AR_ColorPanel1设置到对映Card的颜色

Card更改背影色: SWITCH 多条件判断，这里计算MoM值

Tips: 用year x 100+month 组成一个整数型值，进行m-1计算

AR_CurrMonth = CALCULATE(
    SUM(BO_AR_aging[AR_LC])
)

• 计算当M-1汇总值，因为月份是按12进位，需要处理当前月=1的情况.

AR_PrevMonth =
      var curYEAR=SELECTEDVALUE(BO_AR_aging[YEAR])       //SELECTED YEAR
      var curMonth=SELECTEDVALUE(BO_AR_aging[MONTH])  //SELECTED MONTH
      var prevPeriod=                                                                             //previous period
                if(curMonth=1,                                                                    //current month is Jan
                        (curYEAR-1)*100+12,                                               //previous is Dec of last.year
                         curYEAR*100+curMonth-1)                                    //current month is NOT Jan
       var ret=SUMX(FILTER(ALL(BO_AR_aging),BO_AR_aging[intPeriod]=prevPeriod),[AR_LC]) //SUMX VALUE
RETURN
      ret+0

• 计算两个月差值：这里用AR_diff变量

AR_diff = BO_AR_aging[AR_CurrMonth]-BO_AR_aging[AR_PrevMonth]

• 根据AR_diff变量编写颜色函数，这里用SWITCH设置多个值。

AR_ColorPanel2 = 
    VAR AR_Value=BO_AR_aging[AR_diff]
    RETURN SWITCH(TRUE(),
        AR_Value<-50000000,"#00FF00",      //green
        AR_Value<-10000000,"#00FFFF",     //light green
        AR_Value<0,       "#FFFFFF",          //white
        AR_Value<10000000,"#FFFF00",      //yellow
        AR_Value<50000000,"#FFC0CB",      //pink
        "#FF0000"                         //red
    )

• 将设定的AR_ColorPanel2设置到对映Card的颜色