7.8 PowerBI系列之DAX函数专题-计算季度末或者季度月末的数据

一些知识

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])