dates equal in dax

[Bakhtawar]

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_DATE=BENEFICIARY_START_DATE,AGE_BAND,Null())

i want to rewrite this in DAX..

any idea

[Anonymous · Accepted solution]

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]

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]

i tried but

POLICY_EFFECTIVE_DATE

is not display in list

[az38]

@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]

yes i have these columns in table

[az38]

@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]

see my table name is memeber but i did not get in list

[az38]

@Bakhtawar 

it looks like you create a measure not column. measure could not have a direct relate to column, it should be some calculations

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

[Bakhtawar]

yes i am trying to create measure ..

this expression is in qliksesne .. so i want to rewrite in dax

=IF(POLICY_EFFECTIVE_DATE=BENEFICIARY_START_DATE,AGE_BAND,Null())

[az38]

@Bakhtawar 

try to create new COLUMN as I mentioned before or descibe your further logic if you need measure

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

[Bakhtawar]

i already desfribe my logic is that if both dates are equal then show age_band otherwise null @az38

[az38]

@Anonymous thx.

@Bakhtawar  highly recommend to read this https://docs.microsoft.com/en-us/power-bi/guidance/dax-column-measure-references

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

[Anonymous]

Go to home Tab

Click on NEw Column

Column= If(table[First_date]=table[Second_Date],[Age-band],blank())

Note: replace first_date and second_date with required date columns.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Bakhtawar]

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