Parameters choosing the difference

[krzysztof]

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

[v-yuta-msft · Accepted solution]

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]

Hi krzysztof,

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

Regards,

Jimmy Tao

[krzysztof]

Hi,

I can use parameters to analyze what if but here as You see the parameter is to be used as a filter, will you help me? Maybe You have a different solution

https://drive.google.com/file/d/19Cm7d0qjXHUFEMIUGtGRGxmofwB_-Dbr/view?usp=sharing

[Omega]

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

[krzysztof]

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

[krzysztof]

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