difference of dates

[#1]

hi!

i'm working on this pivot table and i want to create a new column with the difference, expressed in number of month, between the column called "mese anno chiusura" and "mese anno apertura", but as you can see there are some cells that not contain dates because the cases are still open; so how can I get a new column with the difference between the dates and where there is no date in column called "mese anno chiusura" is reported "open" in the new column?!

[alexandros17]

Se mese anno chiusura è una dimensione modificala scrivendo:

If(IsNull([mese anno chiusura]), 'Open', [mese anno chiusura])

Fammi sapere

[ashfaq_haseeb · Accepted solution]

Try below

If(IsNull([mese anno chiusura]), 'Open', [mese anno Apertura]-[mese anno chiusura])

Regards

ASHFAQ