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..
Who is Participating?

Commented:
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

Author Commented:
I.e. todays date...i.e. 22nd feb..then tomorrow it becomes 23rd feb etc...the current date on any day
0

Author Commented:
Many thanks for the feedback.
0

Author Commented:
Slight error we need to divide the difference between todays date less START date ober duration.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.