Forum Discussion

inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago
Solved

Date Range for new column

Need to show when Refer Date is between days 45 and 59.  I was able to get it to show when past 60 days. ( Over 60 Days = IF(Today() >= [REFER_DT] + 60, "Late"))   But can't fiqure out how...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi, 

    please check the below picture and the attached pbix file.

    It is for creating measures.

     

     

    Coming_Due = 
IF ( TODAY () >= [REFER_DT] + 45 && TODAY () <= [REFER_DT] + 59, "coming due" )

     

    How mane days = 
IF ( NOT ISBLANK ( [REFER_DT] ), INT ( TODAY () - [REFER_DT] ) )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi, 

please check the below picture and the attached pbix file.

It is for creating measures.

 

 

Coming_Due = 
IF ( TODAY () >= [REFER_DT] + 45 && TODAY () <= [REFER_DT] + 59, "coming due" )

 

How mane days = 
IF ( NOT ISBLANK ( [REFER_DT] ), INT ( TODAY () - [REFER_DT] ) )