Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

KPI Card Not Showing correct Month

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)
Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

     

    example

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello amitchandak .

       

      Than you for the quick reply.

       

      It did not work as the number is blank:

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

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

     

    Best Regards,

    Jay