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/

     

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
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/