Forum Discussion
Add "%" to Calculation items in Calculation groups.
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/
Super UserHi 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/
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
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/