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.

Anonymous's avatar
Anonymous
Not applicable
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.