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

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi DemandMGR 

 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

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')