Set analysis projection on 24 months

[jmialoundama]

Hi, 

I want to show next 24 months in graph with set analysis. 

My column date which name periode_dual and the format it's "oct 2019". 

I do this set analysis :

 =Count({$<Type_Periode = {$(=MinString([Type Période]))},Pivot_Date_Type = {'Date Entree stock livraison contractuelle'},[Année période] =, [Mois période] =, [Semaine période] =,periode_dual={">$(=MonthStart(AddMonths(Today(), -24)))"}>}entree_stock_pn_ic)

But it's not correct. 

Can you help me please ? 

[mdmukramali]

Dear,

the format of the periode_dual  is MMM YYYY

and in the set analysis, the MonthStart(AddMonths(Today(), -24)) will return the dd-mm-yyyy format.

Can you try like below:

 =Count({$<Type_Periode = {$(=MinString([Type Période]))},Pivot_Date_Type = {'Date Entree stock livraison contractuelle'},[Année période] =, [Mois période] =, [Semaine période] =,periode_dual={">$(=Date(MonthStart(AddMonths(Today(), -24))),'MMM YYYY)"}>}entree_stock_pn_ic)

and make sure the brackets closed.

[jmialoundama]

Hi @mdmukramali 

I try your expression and it's not work . I have nothing in period_dual : 

 =Count({$<Type_Periode = {$(=MinString([Type Période]))},Pivot_Date_Type = {'Date Entree stock livraison contractuelle'},[Année période] =, [Mois période] =, [Semaine période] =,periode_dual={">$(=Date(MonthStart(AddMonths(Today(), -24))),'MMM YYYY')"}>}entree_stock_pn_ic)

[mdmukramali]

Hi,

Can you share a sample data file

[vinieme12]

how was  periode_dual  field created?

best to use the actual date field instead of month year field

 =Count({$<Type_Periode = {$(=MinString([Type Période]))},Pivot_Date_Type = {'Date Entree stock livraison contractuelle'},[Année période] =, [Mois période] =, [Semaine période] =,

YourDateField={">$(=Date(MonthStart(Today(), -24),'YOURDATEFORMAT'))"}>}entree_stock_pn_ic)

replace YourDateField with your actual datefield name

replace YOURDATEFORMAT with the dateformat of yur date field example YYYY-MM-DD or DD/MM/YYYY  etc