Only show positive trending products

[Wout]

Hi Forum,

I only want the positive trending products. See screenshot for more information.

Thanks,  

[Wout]

Kick, is their another solotion? I don't have a continuous data table. 

[vanessafvg]

@Wout define positive trending >0?

[Wout]

@vanessafvg Positive Trending ->  When sales increase per month

[vanessafvg]

@Wout ah ok!  there is the waterfall  chart but it will show both

you could also create a measure i guess that looks at the previous months figure and only returns a value if its greater?

ie.

positive trending = 

var lastmonth = calculate(sum(sales), previousmonth(date[date))

var thismonth = TOTALMTD( sum([Sales]), 'date[date])

Return

calculate(thismonth, thismonth > lastmonth)

i haven't tested it but you get the idea

[Wout]

Thanks for your reply @vanessafvg,

I get the following message: The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

[vanessafvg]

@Wout sorry i have been quite busy

i did the return statement incorrectly, however i am not sure how well its working

positive trending =
var lastmonth = calculate(sumx(Statements,Statements[Paid in]), previousmonth('date'[Date]))
var thismonth = TOTALMTD( sumx(Statements,Statements[Paid in]), 'date'[Date])
Return
if (lastmonth < thismonth, TOTALMTD(sum(Statements[Paid in]), 'date'[Date]), 0)

[Wout]

@vanessafvg thanks for your time and reaction.

I cant refer to the correct column with the SUMX function.

So i tried:

positive trending = 
var lastmonth = calculate(sum([Price]); PREVIOUSMONTH('Tablename1'[SalesDate]))
var thismonth = TOTALMTD(sum([Price]); 'Tablename1'[SalesDate])
Return
IF (lastmonth < thismonth; TOTALMTD(SUM('Tablename1'[Price]);'Tablename1'[SalesDate];0))

But still get an error: The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

[vanessafvg]

@Wout

i think you have your last bracket in the wrong place?

positive trending = 
var lastmonth = calculate(sum([Price]); PREVIOUSMONTH('Tablename1'[SalesDate]))
var thismonth = TOTALMTD(sum([Price]); 'Tablename1'[SalesDate])
Return
IF (lastmonth < thismonth; TOTALMTD(SUM('Tablename1'[Price]);'Tablename1'[SalesDate]);0)

[vanessafvg]

@Wout not sure if that made a difference for you but it worked my side?

[Wout]

Thanks @vanessafvg, the formule is correct now.

But i get the exact same result. 

Some more infromation about the chart:

[vanessafvg]

@Wout it definitely works for me, what date table are you using?

positive trending =
var lastmonth = calculate(sum([Paid out]), PREVIOUSMONTH(Statements[Paid out]))
var thismonth = TOTALMTD(sum([Paid out]), 'Date'[Date])
Return
IF (lastmonth < thismonth, TOTALMTD(sum([Paid out]), 'Date'[Date],0))

see in my script above i use a date table that i have linked it to, you need a continuous date table for date functions

[vanessafvg]

@Wout can you show me what the graph looks like?

so can you plot the new measure plus the old measure which looks at everything

[Wout]

@vanessafvg, the charts are added below.

Do you need additional information?

[vanessafvg]

@Wout very odd, i will have to try and reproduce the issue, will have to be later though!