Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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 .
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.
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 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
Thank you so much it worked perfectly!
@tjeffries ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |