Forum Discussion

tjeffries's avatar
tjeffries
Icon for Helper I rankHelper I
6 years ago
Solved

help 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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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's avatar
    tjeffries
    6 years ago

    Thank you so much it worked perfectly!

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    tjeffries
    Icon for Helper I rankHelper I
    6 years ago

    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

      • tjeffries's avatar
        tjeffries
        Icon for Helper I rankHelper I
        6 years ago

        Thank you so much it worked perfectly!