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 an...
Need Help
amitchandak's avatar
amitchandak
Super 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
      Super 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

        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