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..
route217Asked:
Who is Participating?
 
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
 
route217Author Commented:
I.e. todays date...i.e. 22nd feb..then tomorrow it becomes 23rd feb etc...the current date on any day
0
 
route217Author Commented:
Many thanks for the feedback.
0
 
route217Author 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.

All Courses

From novice to tech pro — start learning today.