Forum Discussion
Helper Ihelp with switch previous month current month
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?
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 .
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.Thank you so much it worked perfectly!
5 Replies
- amitchandak
Super User
tjeffries ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos. - v-easonf-msft
Community Support
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 .
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.
tjeffriesThank 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
