How to display total document number for last month data based on date

[Kamaizziati]

Hi,

I have below data.

Deparment	Subject	Date Submitted
A	Letter	1/7/2017
A	Fax	2/8/2017
B	Memo	2/7/2017
C	Fax	25/6/2017

I need to show the total subject data based on date.

1. Total subject data for previous month (July).

2. Total subject data for this month (August).

How can I show it use Card custom visual and us DAX to display this. Or have any idea to display this?

[v-chuncz-msft · Accepted solution]

@Kamaizziati,

You may add measures as shown below.

this =
CALCULATE (
    COUNT ( Table1[Subject] ),
    Table1[Date Submitted] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
        && Table1[Date Submitted]
            < DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 1, 1 )
)

previous =
CALCULATE (
    COUNT ( Table1[Subject] ),
    Table1[Date Submitted]
        >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
        && Table1[Date Submitted] < DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
)