一些知识
CLOSINGBALANCEQUARTER、OPENINGBALANCEQUATER可用于取出期初期末的数据
需求
实现展示季度末最后一个月份的销售数据
实现
度量值 季度中最后月份的销售额 =
var v_current_qtr= selectedvalue('date'[date]) // get current year and qtr
var v_lm_current_qtr= calculate(
max('date'[month]),
filter(all('date'),'date'[yearqtr]=v_current_qtr)
)// get sales amount of last month of current qtr
return
calculate(sum(order_2[订单金额]),
filter('date','date'[yearqtr] = v_current_qtr && 'date'[month] = v_lm_of_current_qtr)
)
//get sales amount of last month of current qtr
//简单取值季度末最后一天销售额写法:CLOSINGBALANCEQUARTER(SUM(ORDER_2[订单金额],'date'[date])