Previous Month is Blank in Card Visual but not in Table

[amabrenda1986]

Hello 

Please can someone help me understand why I am having this issue and how to resolve it. If i use this formula CALCULATE([Properties],PREVIOUSMONTH('Calendar Table'[Date])) I get this as seen in the screen shot below:

When I try this formula CALCULATE([Properties],PREVIOUSMONTH(LASTDATE('Fact Table 1'[Property CreateDate]))), I get this as seen in the screen shot below

I want the system to calculate the total records for previous month. Your help is most appreciated. 

Even this formar 

Previous Month = CALCULATE([Properties],DATEADD('Calendar Table'[Date],-1,MONTH)), gives me the screen shot below, which is inacurate, because the 8,712 should not have been included in the previous month reported value

[ryan_mayu]

it looks like that your second try returns the correct value.

what's the expected output?

it returns blank is because you don't give the specific month for the card visual, so can't return the last month's value.

it works in the table because for each row there is a month slicer.

[amabrenda1986]

well the expected output should not include the 8712. It should return the sum without 8,712

[ryan_mayu]

what about you sum all the amount and minus the latest month?

pls provide some sample data (not the table visual or the screenshot).

[amabrenda1986]

Hello Ryan 

Please see sample data below

I used the queries for the start and end date:

Start date = #"Date.StartOfYear"(List.Min(Properties[Property CreateDate]))

End Date =#"Date.EndOfYear"(List.Max(Properties[Property CreateDate]))

Used the start and end date to create a table using this query:  = {Number.From(#"StartDate")..Number.From(#"EndDate")}

Followed these steps to create the calenda table

I would expect the previous month total to exclude Property ID = C30, the total of previous month will be 29.

Thanks in advance and for looking into this.

Some columns from my calendar table.