Ahmad16820
New Member
- Joined
- Jan 20, 2017
- Messages
- 1
In powerpivot excel 2016 i write a formula to sum year to date sales using filter function as below:
SalesYTD:=CALCULATE (
[Net Sales],
FILTER (
ALL ( Sales),
'sales'[Year] = MAX ( 'Sales'[Year] )
&& 'Sales'[Date] <= MAX ( 'Sales'[Date] )
)
)
And it's work perfectly now in my data i have a field called "Channel" which i want to filter it in my pivot table but it wont work! Does anybody know how should i fix my formula?!
Thanks in advance...
SalesYTD:=CALCULATE (
[Net Sales],
FILTER (
ALL ( Sales),
'sales'[Year] = MAX ( 'Sales'[Year] )
&& 'Sales'[Date] <= MAX ( 'Sales'[Date] )
)
)
And it's work perfectly now in my data i have a field called "Channel" which i want to filter it in my pivot table but it wont work! Does anybody know how should i fix my formula?!
Thanks in advance...
Last edited by a moderator:
