Question

我有数据,对4年每个月的产品回报有多的看法。

In powerbimap_1 i 逐月(年)概述产品收益。

And in another sheet i gave the overview of the products returns for all years with products as filter. I wanted to filter the data in sheet_2 to show tha data for last 12 months from the selected month_year in my sheet_1.

我以多种方式努力,但iam无法取得预期产出。 Kind!

我试图从表1中储存选定日期,并制定一项措施,从该选定日期渗入数据。但它没有工作。

Answer 1

On your sheet_1, make sure your slicer is synced to sheet_2

Then check the check-box for syncing to page 2

On your sheet_2, use this measure to se the sum of the last 12 months:

Amount R12M = 
 var _LastDate = LASTDATE(dimCalendar[Date])
 var _calc =
    CALCULATE(
        [Amount],  ---<--- Your base measure
        DATESINPERIOD(dimCalendar[Date],_LastDate,-12,MONTH)
    )
return _calc

希望这一帮助!

友情链接