Date Range in filter pane

[BI_Rockstar_265]

Hi Team,

I want no of difference months in filter pane.

if my date field is current month then it should show 0(difference of months)

if my date field is current month -1 then it should show 1

all these values should reflect in filter pane.

[JuanGerardo]

Hi @BI_Rockstar_265, problably the best way to operate with months is to create a correlative number based on month, so you can make these operations easily and avoid extra logic to manage Dec to Jan transitions. For example:

Year(Today()) * 12 + Month(Today())

-

Year(Max(DateField)) * 12 + Month(Max(DateField))

If you create this field in the script (for example MonthOrder), you will get cleaner expressions in your charts.

JG

[BI_Rockstar_265]

Hi Juan,

Its not  working  as i mentioned above.