Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
camilleamiel
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]="-")
 
Thank you for your help.

Camille
1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

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/


 

 

View solution in original post

2 REPLIES 2
VahidDM
Super User
Super User

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/


 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors