Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to use LEFT function in DAX Measure

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.

.

@Dax
@dax @help
@Dax help
@Dax Measure Error
@Daxhelp
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

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

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi Anonymous 
    Please try

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