Last Month DAX not working in Appended table

[Niels_T]

Hello,

I have a Last Month DAX that goes as followed:

Last Month Local Currency Amount = CALCULATE(SUM('xxxxNV$Sales Invoice + Cr_Memo Line'[Local Currency Amount]),PREVIOUSMONTH('Calendar'[Date]))

This DAX loads but it doesn't give me any results in my appended table.

In the non-appended tables it does work and it does give me results. The DAX is similar:

Last Month Local Currency Amount = CALCULATE(SUM('xxxxNV$Sales Invoice Line'[Local Currency Amount]),PREVIOUSMONTH('Calendar'[Date]))

I first thought that the problem is caused by Local Currency Amount (which is also a DAX column), but I also tested it with a non-DAX measure field and it still doesn't work in my appended table.

Could it be that it is because of the fact that it is an appended table?

My 2 appended tables contains:

Table 1: Invoice Lines and Credit Memo Lines

Table 2: Invoice Header and Credit Memo Header

[amitchandak · Accepted solution]

@Niels_T , there can few reasons. First, make sure it is a measure. Calendar table is marked as Date table.

Also, make some date is selected on-page OR calendar ends on the current month

refer why TI fails https://www.youtube.com/watch?v=OBf0rjpp5Hw

[Niels_T]

Switching from column to measure fixed the problem. Thanks!