Start date and end date problem in Calendar

[saumyashah90]

I created two variables of start_date and end_date and den choosed two calendar objects in which for variable

start_date i kept min value=Min(Date) & max value=Max(Date) and for end_date i kept min value=Date($(start_date)) & max value=Max(Date)

Now i have a mini chart consisting of trend lines and pictures

Avg({<Date={'>=$(start_date)&<=$(end_date)'}>} [Metric Value])

It stopped showing n y thing in that column

same thing for the trend line.

Tell me what to write for expressions which already have 3 if conditions in it

[Gysbert_Wassenaar]

Remove the & from the expression:

Avg({<Date={'>=$(start_date)<=$(end_date)'}>} [Metric Value])

[saumyashah90]

If in expression i have

=Num(Sum({<[Sub Dept]={'PWM'}>} [Metrics Value]))

How to put date condition?

[saumyashah90]

Hey its not showing error but now nothing changes in chart according to change in dates in calendar..?what to do?

=if([Sub Dept]='Equity',sum([Metric Value])).....???

and what if like this there are three if condition..??