Forum Discussion

Ubedulla1988's avatar
Ubedulla1988
Regular Visitor
2 years ago
Solved

Need assistance with SWITCH function with positive and negative percentages.

Hi Team, I have a requirement to show "increased", "decreased" and "remained flat at". I have a measure which returns percentage, If the percentage is between -0.05 and 0.05 then "remained flat at"...
Need Help
  • Wilson_'s avatar
    Wilson_
    2 years ago

    Ubedulla1988,

     

    Read the edit in the message you responded to and see if that's what you're looking for.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Remove all the FORMAT stuff, it will convert to string and you don't want that.

It's easier to start with a simple IF to test these things so that you can get something simple to work before writing the whole thing.

Ubedulla1988's avatar
Ubedulla1988
Regular Visitor
2 years ago

Thanks for responding on issue.
Even after removing Formate, still see incorrect results. If you look at the percentage, it is 0.4 which is bigger than 0.05 and It should return "has increased by". But it is returning "has remained flat at".

  • gmsamborn's avatar
    gmsamborn
    Icon for Super User rankSuper User
    2 years ago

    Hi Ubedulla1988 

     

    It looks like you are comparing a percentage with a basic number.

     

    .4% is actually equal to .004 which you are comparing to .05 (5%)

     

    Also, the line comparing _Check with "--" won't do anything since _Check is a number, not a string.