Duplicates in the month

[Shahith]

How to combine the duplicate values of the month (April to Apr and June to Jun) in dimension?

[BrunPierre]

Can you post how the month is derived?

[Shahith]

Thanks for your response, I got it solved by adding a  "Replace" function.

LOAD

    [Month],

     Replace(

    Replace([Month], 'April', 'Apr'),

    'June', 'Jun') as Modified_Month

Resident [Summary];