graph that show the data for the 13 month early to the select date. My table have 3 fields of date

[EmmaMG]

 need to create a graph that show the data for the 13 month early to the select date.

The dificult in this case is that my table have 3 field of date.
It is a table with Date creation, date modified and date closed.

I need to show the petitions that are not resolved in the 13 last month from a period selected

The metric that I need to use is this:

2. Peticiones no resueltas = CALCULATE(COUNTx(FILTER(T_PETICIONES,T_PETICIONES[Fecha apertura]<=max(Calendario[Fecha]) && (ISBLANK(T_PETICIONES[Fecha resolución]) || T_PETICIONES[Fecha resolución]>max(Calendario[Fecha])) && (ISBLANK(T_PETICIONES[Fecha cierre]) || T_PETICIONES[Fecha cierre]>max(Calendario[Fecha]))),(T_PETICIONES[ID_Petición])),CROSSFILTER(T_PETICIONES[Fecha apertura],Calendario[Fecha],None))

Please, could you help me?

[v-yangliu-msft]

Hi  @EmmaMG ,

According to your description, I create some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _select=SELECTEDVALUE('Table'[ Date creation])
return
CALCULATE(COUNT('Table'[Result]),FILTER(ALL('Table'),'Table'[ Date creation]<=_select&&'Table'[ Date creation]>=EOMONTH(_select,-14)&&'Table'[Result]="NO"))

2. Result.

You can downloaded PBIX file from here.

If this is not up to your expected result, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file (please ensure that column headings and data therein are in English) and show the expected result.