Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Shorty_AO
Helper I
Helper I

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
sturlaws
Resident Rockstar
Resident Rockstar

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.

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors