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

Omega's avatar
Omega
Impactful Individual
7 years ago

I belive you need to create your difference % as a column and not as measure in order to drag it to a slicer :)

  • krzysztof's avatar
    krzysztof
    Helper III
    7 years ago
    to create a difference % column, I have to create the values column for the previous month and I do not know how to create such a column. As you can see I created the measure value last month (this is the value of the previous month only name I was wrong) but I can not make a calculated column out of this measure
  • krzysztof's avatar
    krzysztof
    Helper III
    7 years ago

    Do you have an idea how to solve this problem?
    I will be grateful for your help