How to compare Month wise ColumnName Sum of Revenue in sales?

[ishansjain2095]

Hi All,

Facing a problem in comparing month wise sales based on columnname and using the below expression to find out sales dynamically i.e. :

If(SUM({<Date = {"<=$(vCurrentMonthStart)>=$(vCurrentMonthEnd)"}>}[Revenue])
<
SUM({<Date = {"<=$(vPreviousMonthStart))>=$(vPreviousMonthEnd)"}>}[Revenue]),
chr( num#( '31', '(alt)') ),chr( num#( '30', '(alt)') )) & ' ' & Sum([Revenue])

Not able to compare it with last month and current month with '▲' and '▼' symbol used on above expression...

Please help!!!!

[sunny_talwar]

Do you have date or month as your dimension in the chart where you are trying to use this?

[ishansjain2095]

I have integrated month as variable of date...

[ishansjain2095]

In measure using Sum(Sales) and want to use if Condition with chr( num#( '31', '(alt)') ) ->  '▲'  and chr( num#( '30', '(alt)') ) -> '▼'  symbols to find out on which month I sold most/MAX of my items on current as well as previous's month.

But when trying to use above expression I was unable to get correct results.....