Compute the project end date as measure

[aaroh_bits791]

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 business requirement
• Column: End Date (Date data type)
• Column: Progress status (Text data type: from the different status that users can choose such as  Completed, Planning, In Progress  )
• Its to check if the project has overshot by timeline or not.
  
  
• Sample Excel file is attached

I need to calculate

If Today’s date is greater than the End Date (it's already overshot) then show the status in my report it's NOT Completed.

For e.g. Today is 08 Mar 2022 and the project End date was 11 Mar 2022 then I have to the project is NOT completed (not completed yet)
But if the Project End date was 05 Mar 2022, then I don’t have to show this status as it's already completed.

How could I achieve this?

@amitchandak @TheoC @Greg_Deckler 

[VahidDM · Accepted solution]

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/

[aaroh_bits791]

Thank you so much @VahidDM ...

😀