KPI Card Not Showing correct Month

[Anonymous]

Hello All,

The KPI built to represent amount of shipments moved this month x last month is not showing the current month. How can I make so it always shows the comparison between current month and last one?

The number is showing as 8912 

Below the table with the data and KPI

The dax function are as below:

CountShipmentID = CALCULATE(COUNT(Table[ShipmentID])) 

Shipment ID last Month = CALCULATE([CountShipmentID],DATEADD('Invoked Function'[Date],-1,MONTH))

The result I want to show in the KPI is

Goal : 1100

Number : 0 (since there was no shiments in February)

[v-jayw-msft]

Hi @Anonymous ,

Can you show some sample data to us if you don't have any Confidential Information?

Best Regards,

Jay

[amitchandak]

@Anonymous , I think you have to take current month KPI for that

example

MTD Sales = CALCULATE(COUNT(Table[ShipmentID]),DATESMTD('Date'[Date]))

[Anonymous]

Hello @amitchandak .

Than you for the quick reply.

It did not work as the number is blank:

[amitchandak]

@Anonymous , is your page filtered on a date/month. If not, time intelligence will pick up the last date of the calendar

[Anonymous]

@amitchandak No it is not.

The last date on the calendar is on 2025, december. I guess that is why it is showing the month of december?

Filtering the page up till this day did not solve the problem