Forum Discussion
Helper ICompute 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 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?
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/
2 Replies
- VahidDM
Super User
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