Forum Discussion

aishak12's avatar
aishak12
Helper IV
4 years ago
Solved

Two Conditions in IF Statement

Hello,    I have three columns    Column A Column B Column C I would like to create a IF Formula with the following statements:   IF(Query1[Column B] < 40 = Query1[ColumnA] IF Query1[Colu...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi aishak12 

     

    For measure:

     

    IF (
    SELECTEDVALUE ( 'Table'[Column C] ) = "PAN", 45 ,
    IF ( SUM ( 'Table'[Column B] ) < 40, SUM ( 'Table'[Coulumn A] ), 40 )
)

     

    For calcualte colum:

     

    IF ( [Column C] = "PAN", 45, IF ( [Column B] < 40, [ColumnA], 40 ) )

     

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

amitchandak's avatar
amitchandak
Super User
4 years ago

aishak12 , Try like

Sumx(Query1,
Switch(True() ,
Query1[Column B] < 40 ,Query1[ColumnA],
Query1[Column B] > 40 , 40,
Query1[Column C] = "PAN" , 45
))