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 on top of the slicer in which I will put the difference of% months and how I will choose eg 30% will show me the value with a difference of 30% and above

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

6 Replies

  • 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

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

    Hi krzysztof,

     

    Could you please share more details about your requirement and share some sample data?

     

    Regards,

    Jimmy Tao