https://community.sap.com/t5/technology-q-a/replace-blank-values-with-values-with-values-from-another-column/qaa-p/12722747#M4774533 <P><SPAN class="mention-scrubbed">nathan.heath</SPAN></P><P>May be a calculated dimension for date</P><P>IF ( ISNULL ([d\CLOSE_DATE]),[d\RAISE_DATE],[d\CLOSE_DATE])</P><P>Use this calculated dimension in charts/ table</P><P><BR />Hope this helps </P><P>Nikhil</P> Fri, 14 Apr 2023 14:28:05 GMT N1kh1l 2023-04-14T14:28:05Z https://community.sap.com/t5/technology-q-a/replace-blank-values-with-values-with-values-from-another-column/qaq-p/12722746 <P>Hi, </P> <P>I have 2 date columns, one for when a call was raised and one for when a call was closed.</P> <P>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.</P> <P>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.</P> <P>Can anyone help me do this or offer me a better solution?</P> Fri, 14 Apr 2023 13:53:50 GMT https://community.sap.com/t5/technology-q-a/replace-blank-values-with-values-with-values-from-another-column/qaq-p/12722746 NPH 2023-04-14T13:53:50Z https://community.sap.com/t5/technology-q-a/replace-blank-values-with-values-with-values-from-another-column/qaa-p/12722747#M4774533 <P><SPAN class="mention-scrubbed">nathan.heath</SPAN></P><P>May be a calculated dimension for date</P><P>IF ( ISNULL ([d\CLOSE_DATE]),[d\RAISE_DATE],[d\CLOSE_DATE])</P><P>Use this calculated dimension in charts/ table</P><P><BR />Hope this helps </P><P>Nikhil</P> Fri, 14 Apr 2023 14:28:05 GMT https://community.sap.com/t5/technology-q-a/replace-blank-values-with-values-with-values-from-another-column/qaa-p/12722747#M4774533 N1kh1l 2023-04-14T14:28:05Z