Forum Discussion

Buyer_JC78's avatar
Buyer_JC78
Regular Visitor
4 years ago
Solved

DAX Formula including blank cells

I'm looking for some help to return a "Yes", "No" value in PowerBI. I need to identify if my payment date is greater than 60 days (Yes). However, some of the cells are blank and the formula I'm using...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Buyer_JC78 ,

     

    Try this measure:

     

     

    >60 Days Overdue =
IF(
	(NOT ISBLANK([Paid Date]) && [Paid Date] - [Invoice Date] >= 60)
	|| (ISBLANK([Paid Date]) && TODAY() - [Invoice Date] >= 60),
	"Yes",
	"No"
)

     

     

     

    Pete

  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    This might be slightly more reader-friendly:

    >60 Days Overdue = 
VAR _Date = IF ( ISBLANK ( [Paid Date] ), TODAY(), [Paid Date] )
RETURN
    IF ( _Date - [Invoice Date] >= 60, "Yes", "No" )
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

This might be slightly more reader-friendly:

>60 Days Overdue = 
VAR _Date = IF ( ISBLANK ( [Paid Date] ), TODAY(), [Paid Date] )
RETURN
    IF ( _Date - [Invoice Date] >= 60, "Yes", "No" )
BA_Pete's avatar
BA_Pete
Super User
4 years ago

ARGH! Swooped by syntax! ðŸ˜‚