Forum Discussion

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
6 years ago
Solved

dates equal in dax

I have two dates Effec_Date and bene_Date .. i want to euqlas to both dates and want like   if these two both dates are equal then age_band , otherwise null .. like this   =IF(POLICY_EFFECTIVE_D...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Bakhtawar ,

     

    Formula for measure.

    Measure = IF(SELECTEDVALUE('Table'[Effec_Date])=SELECTEDVALUE('Table'[bene_Date]),SELECTEDVALUE('Table'[age_band]),BLANK())

     

    Formula for calculated column.

    Column = IF('Table'[Effec_Date]='Table'[bene_Date],'Table'[age_band],BLANK())

    To create Measures or Calculated columns, please right click on cloumns or tables or find menus under Modeling.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Bakhtawar 

try simple IF

Column = 
IF([POLICY_EFFECTIVE_DATE]=[BENEFICIARY_START_DATE],
[AGE_BAND],
BLANK())

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
6 years ago

i tried but

POLICY_EFFECTIVE_DATE

is not display in list

 

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Bakhtawar 

    do you have such column? how does your data model look like?

    Column = 
IF('TableName'[POLICY_EFFECTIVE_DATE]='TableName'[BENEFICIARY_START_DATE],
'TableName'[AGE_BAND],
BLANK())

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

      

    • Bakhtawar's avatar
      Bakhtawar
      Icon for Post Patron rankPost Patron
      6 years ago

      yes i have these columns in table

      • az38's avatar
        az38
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Bakhtawar 

        in what table are you trying to create a column? if in the same you should see it in drop-down list

         

        do not hesitate to give a kudo to useful posts and mark solutions as solution