Replace blank values with values with values from another column

[NPH]

Hi,

I have 2 date columns, one for when a call was raised and one for when a call was closed.

I have a mix of open and closed calls, the open calls do not have a closed date. I want to be able to show when calls when the open calls were raised and when the closed calls were closed on the same chart.

I want to replace the blank values in the closed date column with the date raised in the model so I can use restricted measures and display them on the same axis.

Can anyone help me do this or offer me a better solution?

[N1kh1l · Accepted solution]

nathan.heath

May be a calculated dimension for date

IF ( ISNULL ([d\CLOSE_DATE]),[d\RAISE_DATE],[d\CLOSE_DATE])

Use this calculated dimension in charts/ table

Hope this helps

Nikhil