KPI card to display current month instead of December previous year

[inahury1]

Struggling to get the KPI visual to display current month. Any help would be appreciated!

I have a measure for the previous monthly usage. 

Prior Monthly Usage = CALCULATE([Usage Days], PREVIOUSMONTH('Usage'[Started].[Date]))  

Then I have another measure to calculate the difference between the current month and previous.

Measure = DIVIDE([Usage Days], [Prior Monthly Usage], BLANK())-1

I want to display the Measure (difference) in the KPI visual but it doesn't want to display the current month. It displays December from the previous year. 

Thank you!

[Ritaf1983]

Hi @inahury1 
Maybe you didn't filter the report / visual.

In this case, the engine default is the end of the current year .
I created an example to show how it works.
With slicer :

Without slicer/filter:

With filter by the "main" measure not blank :

The pbix is attached (the last 3 sheets are examples of what I showed)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[inahury1]

I tried this and it still didn't work. I don't want to add an addtional date filter to the report. I am looking for the KPI card visual to always dynamically return the previous months value. So for example, it is currently June. So looking for it to return the value from May 2024. When July is here, want it to return the June number. 

I can filter the graphic by having it not use the value when Usage Days is blank. However, it still wants to use December 2023 value. 

[Ritaf1983 · Accepted solution]

Hi @inahury1 

To ensure the card functions correctly, it must have a filter. If you need it to be based on the "current month" and not depend on the report filter dynamics, you can use a relative date filter: "This month."

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.