Could you please help me with below scenario.
I have Actual estimated date field with null values. Here I wanted to show if actual estimated date is null values then it should give results as “not started” else should show Actual estimated date (YYQQ) format.
Please find the attached screenshot(input and desired output) for reference and .twbx file.
Create a calculation like below
YYQQ or not Startted:
if ISNULL([Actual Estmated date])
DATENAME('year',[Actual Estmated date])+" Q"+
DATENAME('quarter',[Actual Estmated date])
It will help you give the required O/P
Hope this helps kindly mark this answer as correct/helpful to close the thread