Forum Discussion

donovanm's avatar
donovanm
Frequent Visitor
1 year ago
Solved

IF AND Multiple Conditions

Hi,   I need to create a column where I end up with four possible outcomes based on two conditions relating to various contracts status and the corresponding premium figure.   In Excel it would b...
Need Help
  • donovanm's avatar
    donovanm
    1 year ago

    Hi FarhanJeelani 

     

    Thank you for providing that solution.  I believe that the aggregation is causing the problem here as the data has the premium monthly so the category DAX is being applied at that level.  Ideally I would like to be able to total the months up and then apply the Category to the total.

    e.g. The contracy below has a Total Premium of 968k but it is classfied as Lead and over the 250k threshold yet it is has a Category 2 - I assume because the monthly value is 81k.

     

     

wini_R's avatar
wini_R
Solution Supplier
1 year ago

Hey donovanm,

If you want to add a column in Powe Query you can try the following formula:

if [B2] = "Lead" then 
 if [C2] >= 250000 then "Category 1" else "Category 2"
else if [C2] >= 250000 then "Category 3" else "Category 4"