Created a measure using Previous month and its not working

[Anonymous]

I have a table with Saleamount and saledate, I also have a date table with dates

I have added relationshipbetween date table and sales table and using this query

previousMonth = CALCULATED(SUM(Sales[Saleamount]), PreviousMonth(Date[Date])))

but this query is not populating anything!!! 

Sales table is also related to customer table and customer table is related to another dates table called dates1 

I was not able to link sales table to dates1 as I had a relation with customer already...

can anyone tell what the problem is?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Do you mean when you added the measure [previousMonth] to visual, it shew no results? Please make sure you added [Date] column into visual from calendar table 'Date' rather than 'Sales'.

Regards,

Yuliana Gu

[Anonymous]

Its working now, I missed that.

Thank You!