cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhsieh
Helper II
Helper II

KPI card: want it to show the current Quarter value, instead of Month.

Hi everyone,

I would like the KPI card to show the most current quarter value. Here (see attached screenshot) my KPI card is showing the most current month value, how do I make it to show the most current quarter value instead? I imagine I will need to write a DAX calculation, but I don't know how. If anyone could teach and help me, I would greatly appreciate it!

 

850 = 
IF(
    ISBLANK(
        SUM(Retailer_Compliance[VOL_850])
    ),
    0,
    SUM(Retailer_Compliance[VOL_850]
    )
)

 

 

855 = 
IF(
    ISBLANK(
        SUM(Retailer_Compliance[VOL_855])
    ),
    0,
    SUM(Retailer_Compliance[VOL_855]
    )
)
855_TO_850 = 
IFERROR(
    [855] / [850],
    0
)

 

mhsieh_0-1660241035930.png

1 ACCEPTED SOLUTION
mhsieh
Helper II
Helper II

Hi everyone,

I was able to resolve it myself by calculating the 850_QTD, 855_QTD,  855_TO_850_QTD

850_QTD = 
CALCULATE(
    [850],
    DATESQTD(
        'Calendar Lookup'[Start of Month]
    )
)
855_QTD = 
CALCULATE(
    [855],
    DATESQTD(
        'Calendar Lookup'[Start of Month]
    )
)
855_TO_850_QTD = 
IFERROR(
    [855_QTD] / [850_QTD],
    0
)



View solution in original post

1 REPLY 1
mhsieh
Helper II
Helper II

Hi everyone,

I was able to resolve it myself by calculating the 850_QTD, 855_QTD,  855_TO_850_QTD

850_QTD = 
CALCULATE(
    [850],
    DATESQTD(
        'Calendar Lookup'[Start of Month]
    )
)
855_QTD = 
CALCULATE(
    [855],
    DATESQTD(
        'Calendar Lookup'[Start of Month]
    )
)
855_TO_850_QTD = 
IFERROR(
    [855_QTD] / [850_QTD],
    0
)



Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.