Forum Discussion

krzysztof's avatar
krzysztof
Helper III
7 years ago
Solved

Parameters choosing the difference

I created a table in which there are products and the values for them in the selected month, next to the values in the previous month and measure the difference of%. I would like to put a parameter o...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi krzysztof,

     

    Modify your measure like below and check if it can meet your requirement:

    Diff % Month = 
VAR result = DIVIDE([Value ACTUAL MONTH],[Value Last Month],0)-1
RETURN
IF( result >= (Parametr[Wartość Parametr] / 100), result)

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi krzysztof,

 

Modify your measure like below and check if it can meet your requirement:

Diff % Month = 
VAR result = DIVIDE([Value ACTUAL MONTH],[Value Last Month],0)-1
RETURN
IF( result >= (Parametr[Wartość Parametr] / 100), result)

 

 

Regards,

Jimmy Tao