topic Re: If function with date to return text issues in DAX Commands and Tips

If function with date to return text issues

camilleamiel — Mon, 15 Nov 2021 10:30:25 GMT

Hello PBI community,

I'm pretty new in using PBI,

I am trying to do a If function with a date to return a text and apparently I have issue with the comparaison of these 2 types of values
Could you help with my several tests below ?

test 1:

IF(IS BLANK('BDD projets'[Date envoi mail]),'BDD projets'[Date envoi mail]="Mail à envoyer",'BDD projets'[Date envoi mail]="-")

test 2:

IF('BDD projets'[Date envoi mail])="",'BDD projets'[Date envoi mail]="Mail à envoyer",'BDD projets'[Date envoi mail]="-")

test 3:

IF('BDD projets'[Date envoi mail]=TODAY(),'BDD projets'[Date envoi mail]="Mail à envoyer",'BDD projets'[Date envoi mail]="-")

Thank you for your help.

Camille

Re: If function with date to return text issues

VahidDM — Mon, 15 Nov 2021 10:34:11 GMT

Hi camilleamiel

Test 1 and 2 are same, try this measures:

Test 1 & 2 = IF(ISBLANK(max('BDD projets'[Date envoi mail])),"Mail à envoyer","-")

Test 3 = IF(max('BDD projets'[Date envoi mail])=today(),"Mail à envoyer","-")

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: If function with date to return text issues

camilleamiel — Mon, 15 Nov 2021 11:04:11 GMT

Thank you, I just remove "max" and solution works ! thanks for your help !