Calculated Measure

[swathrddy]

KPI No	Value	Date
2.1.1 Actual	Yes	Jun-24
2.1.1 Target	Yes	Jun-24

write a calculated measure to return TEXT from Column value for KPI no = 2.1.1 Actual and date = Jun-24

Wrote this, but is giving only if the Value ie "YES"

CALCULATE(

    MIN('Data File for PB'[Value]),

    'Data File for PB'[KPI No] IN { "2.1.1 Actual" },

    'Data File for PB'[Date] >= "1/06/2024"

)

I would like to return the exact text for the condition. 

Appreciate your help.

[v-junyant-msft · Accepted solution]

Hi @swathrddy ,

Based on the information you provided, it looks like the data type of this column is date:

But you used this in DAX:

>= "1/06/2024"

This is equivalent to comparing dates and text, which is incorrect. Please modify it to the following DAX:

Measure = 
CALCULATE(
    MIN('Data File for PB'[Value]),
    'Data File for PB'[KPI No] IN { "2.1.1 Actual" },
    'Data File for PB'[Date] >= DATE(2024, 6, 1)
)

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[swathrddy]

Not returning any value 😞

I have the following target types, in one single table.

Trying to add headline numbers for current month "Yes". Calculated measure should pull the text YES / NO for current month from Values column.

[bhanu_gautam]

@swathrddy , Try using below DAX

DAX
Measure =
CALCULATE(
SELECTEDVALUE('Data File for PB'[Value]),
'Data File for PB'[KPI No] = "2.1.1 Actual",
'Data File for PB'[Date] = "Jun-24"
)