https://community.fabric.microsoft.com/t5/Report-Server/power-bi/m-p/362951#M4057 <P>Hi Using Power BI Most current Version</P><P>&nbsp;</P><P>New to power bi learn DAX formula. How would you wright a DAX Formula to do the following..</P><P>Column A RAG Status</P><P>Column B Start Date</P><P>Column C End Date</P><P>Column D Duration B-C</P><P>&nbsp;</P><P>so if the Rag in column A is Blue then return in a new column 100% other wise if the Rag in column A is either Red or Amber then (workout). Today's date less the start date column B / by the Duration in column D and express as a percentage.</P> Thu, 22 Feb 2018 07:39:59 GMT Anonymous 2018-02-22T07:39:59Z https://community.fabric.microsoft.com/t5/Report-Server/power-bi/m-p/362951#M4057 <P>Hi Using Power BI Most current Version</P><P>&nbsp;</P><P>New to power bi learn DAX formula. How would you wright a DAX Formula to do the following..</P><P>Column A RAG Status</P><P>Column B Start Date</P><P>Column C End Date</P><P>Column D Duration B-C</P><P>&nbsp;</P><P>so if the Rag in column A is Blue then return in a new column 100% other wise if the Rag in column A is either Red or Amber then (workout). Today's date less the start date column B / by the Duration in column D and express as a percentage.</P> Thu, 22 Feb 2018 07:39:59 GMT https://community.fabric.microsoft.com/t5/Report-Server/power-bi/m-p/362951#M4057 Anonymous 2018-02-22T07:39:59Z