Forum Discussion

aaroh_bits791's avatar
aaroh_bits791
Icon for Helper I rankHelper I
4 years ago
Solved

Compute the project end date as measure

Hello everyone,   I have a requirement as follows: Data is from an Excel file and stored on SharePoint Site. The Excel file has many columns but  the main part that I need to use for that is a b...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    HI aaroh_bits791 

     

    If I got your point correct, then try this measure:

     

    Progress status = 
Var _Today = TODAY()
return
if(MAX('Table'[END DATE])<=_Today,blank(),"Not Completed")

     

    Output:

     

     

     

     

    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/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

HI aaroh_bits791 

 

If I got your point correct, then try this measure:

 

Progress status = 
Var _Today = TODAY()
return
if(MAX('Table'[END DATE])<=_Today,blank(),"Not Completed")

 

Output:

 

 

 

 

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/