Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am writing a set expression with bookmark filter and other filters. But it is not working fine.When I am apllying BM(Id-qjyVTq) separately it is working fine like below.
sum({qjyVTq}[Sales Amt])
And when applying other filter it is also working fine
sum({$<[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])
Now I want to combine this two like below
sum({$<{qjyVTq},[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])
But this not working.
Experts Please help me on this.
For non-overlapped set:
sum({ qjyVTq <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])
For overlapped set using OR operator:
sum({ qjyVTq + <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])
let's try the below expression:
=sum( {qjyVTq * < [Product Type] = {'MF'}, [Process Date]={">=$(=QuarterStart(Max([Process Date])))<=$(=Max([Process Date]))"} >} [Sales Amt] )
For non-overlapped set:
sum({ qjyVTq <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])
For overlapped set using OR operator:
sum({ qjyVTq + <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])