Calculated Column

[Anonymous]

Hi All,

I have a below column in my data set "ROLLING_FISCAL_QUARTER" which i have modified to show the data like 0 will be Q0, -1 will be Q-1 and so on but I can see a blank value also present in my new calculation. Is there a way I can add the blank value to my last value shown i.e Q-5 +?

[Anonymous]

I tried changing the formula but still its not working

Any help here?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please update the formula of your calculated column as below and check if you can get the expected result...

BatchSort1 =
SWITCH (
    TRUE (),
    'VM_D_DATE'[ROLLING_FISCAL_QUARTER] = BLANK (), "Q-5+",
    'VM_D_DATE'[ROLLING_FISCAL_QUARTER] = 0, "Q0",
    'VM_D_DATE'[ROLLING_FISCAL_QUARTER] = -1, "Q-1",
    'VM_D_DATE'[ROLLING_FISCAL_QUARTER] = -2, "Q-2",
    'VM_D_DATE'[ROLLING_FISCAL_QUARTER] = -3, "Q-3",
    'VM_D_DATE'[ROLLING_FISCAL_QUARTER] = -4, "Q-4",
    "Q-5+"
)

Best Regards