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

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