How to write set analysis for dates

[rahulhv1]

I want below to work.

=SUM({< [FinanceRelease] = {$(=(CalendarDate))} >}  [Capex Item Gross Value])

where selected CalenderDate is 31-07-2014  (All the date formats are same i.e. DD-MM-YYYY)  then also this is not working

where as

when i write 

=SUM({< [FinanceRelease] = {'31-07-2014'} >} [Capex Item Gross Value])

it works perfectly ok.

[avinashelite]

Try like this

SUM({< [FinanceRelease] = {'$(=CalendarDate)'} >}  [Capex Item Gross Value])

[manideep78 · Accepted solution]

HI Rahul, try like this

=Sum({<[FinanceRelease]={'$(CalendarDate)'}>}[Capex Item Gross Value])

OR

=Sum({<[FinanceRelease]={"$(CalendarDate)"}>}[Capex Item Gross Value])

It should work.

Regards,

Manideep

[rahulhv1]

Nope its not working Avinash

[PrashantSangle]

Hi,

Kindly check the following steps,

1: check that what it returns when you type in $(=(CalendarDate)) in text Object

2: use similar expression which you are trying in expression variable in your set analysis

3: Also check that after your expression execution your variable is still giving you out put in date format or number format.

Regards

[rahulhv1]

=Sum({<[FinanceRelease]={"$(CalendarDate)"}>}[Capex Item Gross Value])

This is working i.e. WHEN I USED Double Quote , it worked perfectly ok. But now the problem is other

i want to you <= i.e. date < or = ,

=Sum({<[FinanceRelease]={"$(<= CalendarDate)"}>}[Capex Item Gross Value])

is not working.

[manideep78]

Like this:

=Sum({<[FinanceRelease]={<="$(CalendarDate)"}>}[Capex Item Gross Value])

Regards,

Manideep

[rahulhv1]

Nope, I already tried that,

=Sum({<[FinanceRelease]={"$(= max(CalendarDate))"}>}[Capex Item Gross Value])

this works but when i put <  it dos't work enven if i write as per your above statement, it do not work. It give syntax error (Red line)

[manideep78]

Hi Rahul

Try this: (Include <= symbol in double quotes before $ symbol)

=Sum({<[FinanceRelease]={"<=$(CalendarDate)"}>}[Capex Item Gross Value])

This will work for sure.

Regards,

Manideep

[rahulhv1]

no.. its not working