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

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