Dax formula

Hi Experts...

How wpuld you wright a DAX formula to do the following result..
COLUMN A RAG STATUS...
COLUMN B START DATE
Column C END DATE
COLUMN D DURATION B - C

if in column A the rag is blue then 100% otherwise if the rag is red or amber then (work out) the following.

Today's date less start date column B then divide that by duration in column D..
route217JuniorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

abbas abdullaCommented:
Hi,
Check this function in calculated column =IF([RagStatus]="blue",1,IF(TODAY()<[StartDate],[StartDate]/[Duration],0))

What do you mean by that in this sentence "Today's date less start date column B then divide that by duration in column D.."
divide that? what is that? Is it StartDate/Duration or I understood it wrong?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
route217JuniorAuthor Commented:
I.e. todays date...i.e. 22nd feb..then tomorrow it becomes 23rd feb etc...the current date on any day
0
route217JuniorAuthor Commented:
Many thanks for the feedback.
0
route217JuniorAuthor Commented:
Slight error we need to divide the difference between todays date less START date ober duration.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DAX

From novice to tech pro — start learning today.