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.

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

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

        this same table but i did not get field names ...even table does not appear ... what should i do