How to use LEFT function in DAX Measure

[vishu263]

Hello @tamerj1 ,

Can you please show how to write a DAX measure based on the below logic. I am confused whether to use SUBSTRING or LEFT function here.

=(((If ([Orange] > [Apple]) Then [Apple] Else [Orange]) Where(Left([Fruit_category]; 3) = "INC")) / 60)

Fruit Category column is attached for reference. Thanks in advance.

.

[tamerj1 · Accepted solution]

Hi @vishu263 
Please try

=
CALCULATE (
    VAR Orange = [Orange]
    VAR Apple = [Apple]
    RETURN
        IF ( Orange > Apple, Apple, Orange ),
    LEFT ( [Fruit_category], 3 ) = "INC"
) / 60