Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add "%" to Calculation items in Calculation groups.

I am having trouble with two things:   1. I have a time intellegence calculation item called YoY%. I am getting the value, however I ran into a problem when I included the % symbol against each ret...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Anonymous 

     

    Change the measure format:
    1 - you can add format to the DAX code:

     

     

     

    VAR CY =
    SELECTEDMEASURE ()
VAR PY =
    CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )
VAR YOY = CY - PY
RETURN
    FORMAT ( DIVIDE ( YOY, PY ), "Percent" )

     

     

     

     

    2 - Change the Measure format:

     

     

     

    VAR CY =
    SELECTEDMEASURE ()
VAR PY =
    CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )
VAR YOY = CY - PY
RETURN
    DIVIDE ( YOY, PY )

     

     

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi VahidDM , Thanks for the solution. 

 

Second one, I have created measures via calculation groups which are created in tabular editor. The ribbon on Measure tools is not editable for themeasures. 

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

Does the first one work for you? or in the Tabular Editor set the measure as this:

 

 


Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/