https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921535#M152628 <P>Perfect! Thank you!</P> Wed, 15 May 2024 18:44:05 GMT racheljeska 2024-05-15T18:44:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921505#M152625 <P>Column [Will Evaluation be Required?] has choices of True, False, or Blank</P><P>Coulmn [Date Evaluation Completed] gives a date or is blank if not completed</P><P>&nbsp;</P><P>I want a new column that says:</P><P><SPAN><SPAN class="">If [Will Evaluation be Required?] is true, then for all the [Date Evaluation Completed] blank items= open</SPAN></SPAN></P><P><SPAN><SPAN class="">and items with a date= completed</SPAN></SPAN></P><P>&nbsp;</P><P><SPAN><SPAN class="">Thank you!&nbsp;</SPAN></SPAN></P> Wed, 15 May 2024 18:29:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921505#M152625 racheljeska 2024-05-15T18:29:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921522#M152627 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="743628" data-lia-user-login="racheljeska" class="lia-mention lia-mention-user">racheljeska</a>&nbsp;</P><P>Please try below dax to add new calculated column:</P><P><SPAN>Evaluation_Status = IF( [Will Evaluation be Required?] = TRUE(), IF( ISBLANK([Date Evaluation Completed]), "Open", "Completed" ), BLANK() )</SPAN></P><P>&nbsp;</P><P class=""><STRONG><SPAN class="">Learn Power BI free:</SPAN></STRONG></P><P class=""><SPAN class=""><A href="https://analyticpulse.blogspot.com/?m=1" target="_blank" rel="noopener">https://analyticpulse.blogspot.com</A></SPAN></P><P class=""><SPAN class=""><A title="Power BI : getting started " href="https://analyticpulse.blogspot.com/p/introduction.html?m=1" target="_self">Power BI : getting started </A></SPAN></P><P class=""><SPAN class=""><A title="Dax Functions " href="https://analyticpulse.blogspot.com/p/dax-functions.html?m=1" target="_self">Dax functions </A></SPAN></P><P class=""><SPAN class=""><A title="powerbi Visualisation " href="https://analyticpulse.blogspot.com/p/creating-visualizations.html?m=1" target="_self">powerbi Visualisation </A></SPAN></P> Wed, 15 May 2024 18:39:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921522#M152627 AnalyticPulse 2024-05-15T18:39:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921535#M152628 <P>Perfect! Thank you!</P> Wed, 15 May 2024 18:44:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-New-Calculated-Column/m-p/3921535#M152628 racheljeska 2024-05-15T18:44:05Z