cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## If function with date to return text issues

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]="-")

Camille
1 ACCEPTED SOLUTION
Super User

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.

2 REPLIES 2
Super User

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.

New Member

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors