Problem trying to calculate previous month totals

[BadenhoA]

I am trying to do a report on printing so we can watch the increase or decrease in printing as a percentage.

However no matter what I try the totals of socalled previous month is equivalent to to current month or depending on what I do no value at all.

 

I have tried with seprate date table added. No difference. also tried dateadd and previousmonth options still no joy.

I either get no value or as you can see wrong value.

Thanks

[v-haibl-msft]

@BadenhoA

You need to create a calendar table firstly with formula like below.

Calendar = 
CALENDAR ( "1/1/2016", "12/31/2017" )

And create relationship between the Calendar table with the fact table.

Then we only need to create a measure with following expression.

LM = 
CALCULATE (
    SUM ( Table1[Total Printed Pages] ),
    PREVIOUSMONTH ( 'Calendar'[Date] )
)

Best Regards,
Herbert

[BadenhoA]

Thanks for the reply.

This is exactly what id did I have tried with external table using the internal date field.

None of the options produce the correct result no matter as I mention if I use Previousmonth, dateadd or parallelperiod pointing to either internal or external date table with the relationship set up.

For some weird reason it is not working. 

I am starting suspect that the problem might be regional formatting.

I will try a few more things before giving it up. 

I have reverted to the March 10 version of PowerBI Desktopas was suggested as well still no joy.

[v-haibl-msft]

@BadenhoA

If possible, could you please provide your PBIX file to me? I can take a look at it.

Best Regards,
Herbert

[BadenhoA]

I can do that no problem at all .

You can get the file from here: https://www.dropbox.com/s/eo3c1s1ww2rn37g/Old%20Test.pbix?dl=0

Thanks

[v-haibl-msft]

@BadenhoA

Please try with following measure formula.

LM = 
CALCULATE (
    SUM ( 'Printer Data'[Total Printed Pages] ),
    PREVIOUSMONTH ( 'Calendar'[Date] ),
    ALLSELECTED( 'Printer Data' )
)

Best Regards,
Herbert

[BadenhoA · Accepted solution]

Thanks for the hint

This folowing formula worked :

LM =
CALCULATE (
    SUM('Printer Data'[Total Printed Pages]) ;
    PREVIOUSMONTH( 'Printer Data'[Date]) ;
    ALLSELECTED('Printer Data')
)