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.
I think it should work
no, sir, it doesn`t (
if works well when u choose all months
but it doesn`t , when u use date filter:
Its working for me.
I thinks this is the approach.
thats what iam talking about @VijayP
Will this Do?
@VijayP looks similar.
could u please share the pbix ?
Please share Kudoes and Please mark this as solution
View solution in original post
@VijayP thank you so much!
Please share your Kudoes, Many if possible hahahahah 😂
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021