Forum Discussion

Nick221_'s avatar
Nick221_
Frequent Visitor
1 year ago

Percentage Change DAX formula

I have two measures "Start Month" and "End Month" in two cards. Below is the formula for these measures.    I have added two individual slicers by Month. Is it possible to calculate the perce...
Nick221_'s avatar
Nick221_
Frequent Visitor
1 year ago

what does the _change represent in the divide calculation? I receive the below error.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Nick221_ 

 

This is a syntax error, you need to give the measure a name.

For example,

Measure = 
VAR _change = [EndMonth] - [StartMonth] 
RETURN
DIVIDE( _change, [StartMonth] )

The _change is a variable to store the value of the [EndMonth] - [StartMonth].

 

Hope this can help.

 

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.