help with switch previous month current month

[tjeffries]

Hi I'm using the switch function, to replace month number with month name, I need to replace any month name in the past with the current month i.e. replace May with Jun

here is what I have so far

Order date =

SWITCH (

   orders[est ship date Month Number],

    1, "JAN",

    2, "FEB",

    3, "MAR",

    4, "APR",

    5, "MAY",

    6, "JUN",

    7, "JUL",

    8, "AUG",

    9, "SEP",

    10, "OCT",

    11, "NOV",

    12, "DEC",

    BLANK (),"No ship date"

)

can this be done using the switch?

[v-easonf-msft · Accepted solution]

Hi , @tjeffries 

If I understand your request correctly, you want to convert the past month to the current month  and the future month remains unchanged.

You may refer to this sample pbix file .

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-easonf-msft · Accepted solution]

Hi , @tjeffries 

If I understand your request correctly, you want to convert the past month to the current month  and the future month remains unchanged.

You may refer to this sample pbix file .

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tjeffries]

Thank you the file worked I did want to convert the past month to the current month and the future month remains unchanged.  However I forgot that the months that are blank need to say "no date".  Can you help.. please

[v-easonf-msft]

Hi , @tjeffries 

Please check the new pbix file.

pbix attached

Best Regards,
Community Support Team _ Eason

[tjeffries · Accepted solution]

Thank you so much it worked perfectly!

[amitchandak]

@tjeffries ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.