cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

KPI YE Goal DAX

Hello,

 

I have created a KPI to measure our inventory to YE balance in 2019.  The KPI was working correctly until I added November 2019 data.  Now the KPI is showing the Combined amounts rather then just Dec 2019.  How do I adjust my measure below to only show Dec-19 balance?Capture.2.PNGCapture.PNG

 

Thanks in Advance

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: KPI YE Goal DAX

Hi @Shorty_AO 

 

use something like this:

YE_Bal =
RETURN
    CALCULATE (
        [Total Inv],
        FILTER (
            ALL ( 'Calendar' ),
            'calendar'[year] = YEAR ( TODAY () ) - 1
                && 'calendar'[month] = 12
        )
    )

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Highlighted
Frequent Visitor

Re: KPI YE Goal DAX

Thanks.  I was able to use DATESBETWEEN('Calendar'[Date],"12/01/2019","12/31/2019")) to get it to work.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.