Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF statement in dax

Hello!! I have a question about IF en DAX, I hope someone  could helpme   I have this values 10000 345.67 897.01 100 750 783 321.45 890.5 0 etc   I want to check if the number afther t...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Mónica,

     

    Try this formula, please.

    Column =
IF (
    SEARCH ( ".", [Value],, 9999 ) = 9999,
    1,
    IF ( RIGHT ( [Value], 2 ) = "00", 1, 0 )
)

    IF_statement_in_dax

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Mónica,

 

Try this formula, please.

Column =
IF (
    SEARCH ( ".", [Value],, 9999 ) = 9999,
    1,
    IF ( RIGHT ( [Value], 2 ) = "00", 1, 0 )
)

IF_statement_in_dax

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI v-jiascu-msft

 

Thanks for your help!!

It works perfect

 

Greetings 

Mónica