I think the solution is not difficult, but I still can't find it. Could you help me?
The task - find measure average by filtered date perion in pivot table by each objects (object - rows, month - columns).
For this, i use such formula:
and it works fine, till i have to use month slicer to change full year to 10 month, for example.
The "test" still calculate the whole year average.How could I avoid it? And get dynamic average, depends on choosing months?
Lind to db: https://gofile.io/d/VLBPTf
How it should be (11 months):
Go to Solution.
Please share Kudoes and Please mark this as solution
View solution in original post
@KonstantinD , Try if one of these can work
This year = CALCULATE([Measure],DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
This Year = CALCULATE([Measure],filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Proud to be a Super User!
there are no working formulas, unfortunately. And moreover, it shouldn't be used only for current/last year.Cause, pivot table is filtered by years also.
Please try this! Please share your Kudoes!
nice to see you
i tried it. This formula gives the each month measure.
However, I need to find average measure on choosing period using slicer.
Ok, I will prepare data.
Try that measure what you calculate is showing Average by using AVERAGE or AVERAGEX function and then incorporate in my Formula and hope that works! 👍
i use such formula as measure:
added data and desired result in the heading.
Could you please lend a hand?
Please find attached file with solution. let me know whether you are looking for this
no, it doesn`t work (
It should works like "Average sales per FY" but be date filter depended.
For example, if you choose 1-11 months,
it should be 25 849,87 in every cell.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021