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

[mhsieh]

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 · Accepted solution]

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
)