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...
  • v-easonf-msft's avatar
    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!