汇总表数据来自主表,通过DATESINPERIOD函数确定汇总时间段,如何在报表页用时间切片进行任意选择日期筛选生成汇总,实现自建汇总表的动态查看。目前只能手动填写日期
DAX six month table = SUMMARIZECOLUMNS(
Main[Material Entered],DATESINPERIOD(Main[Date],"9/1/2018 12:00:00 AM",-6,MONTH),
"Selected month actual",SUMX(Main,[Actual]),"Selected month consnsus",SUMX(Main,[Consensus]),"选定",Main[选定日期])