Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have problem in set analysis
my expression is
sum({<[GL Date]={">=$(=Start Period)"}>}[Net Amount])
here Start Period values are periodstartdate,quarterstartdate,yearstartdate
all date fields are in timestamp format .
if im using expression like
sum({<[GL Date]={">=$(=periodstartdate)"}>}[Net Amount])
this expression working fine.
but problem with start period
how to use these type of values in setanalysis.
hi
the Start Period is a Field then period,quarter and years is data ?
Please explain the outcome of your expression what you want.
Try this,
sum({<[GL Date]={">=$(=[Start Period])"}>}[Net Amount])
Use a [ ] at Start Period.
Regards
Jyothish KC
Hi
here start period values are period start date,quarter start date,year startdate,
these are also fileds
Try this
sum({<[GL Date]={'>=$(=Date([Start Period]))'}>}[Net Amount])
Hi
i already try this,but this is also not working
here start period representing another field values
i think the Start Period is Table name and the date,quarter and yearstartdate are field of Start Period ?
sum({<[GL Date]={">=$(Start Period)"}>}[Net Amount])
remove '=' and try
Please share your sample app.