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..