Forum Discussion

DemandMGR's avatar
DemandMGR
Helper I
4 years ago
Solved

Custom Column or Dax Formula

I am tying to write a Dax Formula or a Custom Column, preferrably a custom column.   I want the formula to reference two Date columns. The two columns are ETADATE and APPTDATE. My goal is to idenit...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    DemandMGR , Small correction on what @ryan has suggested. Please create a new custom column with below code:-

     

    column  = IF (
    ETADATE = TODAY ()
        || ETADATE
            = TODAY () + 1
        || ETADATE
            = TODAY () + 2,
    "PO#",
    "NO"
)

     

    Thanks,

    Samarth

     

DemandMGR's avatar
DemandMGR
Helper I
4 years ago

What I am looking for is something like an IF(OR) fucntion from excel. Please see example below.

 

IF(OR(ETADATE=TODAY(),ETADATE=TODAY()+1,ETADATE=TODAY()+2),"PO#","NO")

 

Honestly I think I can figure out the rest from there. I am not even sure if this is possible but I am hoping it is

 

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

DemandMGR 

pls try this

IF(ETADATE=TODAY() || ETADATE=TODAY()+1 || ETADATE=TODAY()+2),"PO#","NO")

  • DemandMGR's avatar
    DemandMGR
    Helper I
    4 years ago

    Thank you for that. It didnt work though. There was an error under the E in the second ETADATE.

     

    The examle of how I entered it below.

     

    =IF([ETADATE]=TODAY() || [ETADATE]=TODAY()+1 || [ETADATE]=TODAY()+2),[PO#],'NO')

     

    I have never seen an error under one letter when pulling in a column from the table. 

     

     

    • DemandMGR's avatar
      DemandMGR
      Helper I
      4 years ago

      I also tried this formula but I kept getting a error trying to close the formula 

       

      IF([ETADATE]=TODAY(),[PHPONO],IF([ETADATE]=TODAY()+1,[PHPONO],IF([ETADATE]=TODAY()+2,[PHPONO] ,'NO')

      • Samarth_18's avatar
        Samarth_18
        Community Champion
        4 years ago

        DemandMGR , Small correction on what @ryan has suggested. Please create a new custom column with below code:-

         

        column  = IF (
    ETADATE = TODAY ()
        || ETADATE
            = TODAY () + 1
        || ETADATE
            = TODAY () + 2,
    "PO#",
    "NO"
)

         

        Thanks,

        Samarth

         

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      4 years ago

      DemandMGR 

      pls try to use DAX to create a colum, not in PQ.