Show data for Current month

---

NeonX91 wrote:

Hi,

 

I know there are alot of similair questions, however none seem to address my specific question.

 

I have a date table and an object table
Each object has a date it was created.

Using count formulas, I can easily display how many objects were created per month, this is no problem.

January = 6
Feburaby = 7
March = 10 etc

 

However, I'm trying to do the following and I can't seem to get the right output.

1. Have a 'card' that displays the current month (dynamic)
2. Have a card that displays the previous month (dynamic)
3. Have a card that displays these as a % difference. (dynamic)

 

I can't even get past the first step.
I'm using the measure below

 

CurrentMonth = CALCULATE(COUNT(XXX[Number]),DATEADD('Date'[Month],0,MONTH))
However this measure is just showing the TOTAL count of objects, not the TOTAL count of objects for THIS month.

Any ideas?

---

You can try create 3 measure as below and put them to card visuals.

currentMonth =
SUMX (
    FILTER (
        table,
        DATE ( YEAR ( table[date] ), MONTH ( table[date] ), 1 )
            = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
    ),
    table[amount]
)


previousMonth =
SUMX (
    FILTER (
        table,
        DATE ( YEAR ( table[date] ), MONTH ( table[date] ), 1 )
            = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
    ),
    table[amount]
)


diff % =
DIVIDE ( [currentMonth] - [previousMonth], [previousMonth] )