Forum Discussion

CierrahW's avatar
CierrahW
Regular Visitor
6 years ago

If Then Formula

How would you write a formula for a new column that only populates the value from the "YTD-2020M06-Installation Jobs" column if the value in the "Booked vs Actual" column is "Total Booking" AND the value in the "Sell Price/Earned Revenue & Gross Margin/Gross Profit" column is "Gross Margin/Gross Profit"? 

 

 

 

Formula
If Then
sumx

2 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    Hello CierrahW 

     

    Use the following DAX as calculated column:

     

    Output = 
IF(
  [Booked vs Actutal] = "Total Booking"
   && [Sell Price/Earned Revenue & Gross Margin/Gorss Profit] = "Gross Margin/Gross Profit",
      [YTD-2020M06-Installation Jobs]
)

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
    If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

    Blog: vivran.in/my-blog
    Connect on LinkedIn
    Follow on Twitter

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    CierrahW ,

    In M - edit Query

    if [Booked vs Actual] = "Total Booking" and [Sell Price/Earned Revenue & Gross Margin/Gross Profit] = "Gross Margin/Gross Profit" then [YTD-2020M06-Installation Jobs]

    if [Booked vs Actual] = "Total Booking" && [Sell Price/Earned Revenue & Gross Margin/Gross Profit] = "Gross Margin/Gross Profit" then [YTD-2020M06-Installation Jobs]

     

    In Dax,  new Column

    if ([Booked vs Actual] = "Total Booking" && [Sell Price/Earned Revenue & Gross Margin/Gross Profit] = "Gross Margin/Gross Profit" , [YTD-2020M06-Installation Jobs] , blank() )