Get current month and previous month in two columns

[amybirc77]

Hi All,

I have a table which shows total charges, How to i get the values charges for the current month in one column and for the previous month in another column. I can set filters , but how can i do it automatically? without me going and changing it at the EOM. Please advice.

I am connecting to SSAS Cubes and We ddeploy this to the report server, my new measure is greyed out, to try something like this

current_month_sales = CALCULATE(SUM('Table1'[Sales]),FILTER('Table1',MONTH('Table1'[Month])=MONTH(TODAY())))

Thanks

[johnt75]

If you have a Year Month column in your Date table then the measure for the current month could be

Current Month Sales =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    'Date'[Year Month] = FORMAT ( TODAY (), "YYYYMM" )
)

and previous month would be

Prev month sales =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    TREATAS ( { TODAY () }, 'Date'[Date] ),
    PREVIOUSMONTH ( 'Date'[Date] )
)

[amybirc77]

thanks @johnt75 I have a date heirarchy YEAR SALES.CREATEDATE,MONTH,QUARTER,YEAR.

So i used this

Current Month Sales1 =
CALCULATE (
SUM ( 'Transactions'[Set 01 Charge Amount] ),
'Transactions'[Charge Create Date.Month] = FORMAT ( TODAY (), "YYYYMM" )
)

And it did not return nothing at all.

I tried this as well and did not get any values. Please advice

Previous = CALCULATE(SUM('Transactions (2)'[Set 01 Charge Amount]),PREVIOUSMONTH('Transactions (2)'[Charge Create Date.Date]))

Thanks

[amybirc77 · Accepted solution]

FInally this worked

Current Month Value = CALCULATE(SUM('Transactions (2)'[Set 01 Charge Amount]),MONTH('Transactions (2)'[Charge Create Date.Date])=MONTH(TODAY()))

Thanks