https://community.fabric.microsoft.com/t5/Developer/Project-Online/m-p/3726165#M49802 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/695347">@Pankhuri_16</a>&nbsp;,</P> <P>&nbsp;</P> <P>Adding custom date columns in Project Online requires setting up the use of custom fields through the Project Web App (PWA)</P> <P><A href="https://learn.microsoft.com/en-us/project-for-the-web/add-custom-column-project-power-app#add-a-custom-column-using-the-power-app-portal" target="_blank">Add a custom column to the Project Power App - Project for the web | Microsoft Learn</A></P> <P>&nbsp;</P> <P>If you want to add a new date column in Power BI after importing Project Online data, you can check the following:</P> <P>Create custom columns in the Power Query editor:</P> <P><A href="https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview" target="_blank">Query overview in Power BI Desktop - Power BI | Microsoft Learn</A></P> <P><A href="https://learn.microsoft.com/en-us/power-query/add-custom-column" target="_blank">Add a custom column - Power Query | Microsoft Learn</A></P> <P>Use the Dax function to create custom columns:</P> <P><A href="https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns" target="_blank">Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn</A></P> <P>Refer to:</P> <P><A href="https://community.fabric.microsoft.com/t5/Desktop/Create-a-custom-column-with-a-new-date-based-off-another-s/m-p/946070#:~:text=1.%20Add%20Column%20-%3E%20Custom%20Column.%202.%20Type,get%20a%20custom%20column%20that%20meets%20your%20requirements." target="_blank">Solved: Create a custom column with a new date based off a... - Microsoft Fabric Community</A></P> <P><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-project-online-connect-to-data" target="_blank">Project Online: connect to data through Power BI Desktop - Power BI | Microsoft Learn</A></P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly.</P> Tue, 27 Feb 2024 05:59:42 GMT Anonymous 2024-02-27T05:59:42Z https://community.fabric.microsoft.com/t5/Developer/Project-Online/m-p/3723388#M49756 <P>How do we add a new date column as custom column in project online ?</P> Mon, 26 Feb 2024 09:09:36 GMT https://community.fabric.microsoft.com/t5/Developer/Project-Online/m-p/3723388#M49756 Pankhuri_16 2024-02-26T09:09:36Z https://community.fabric.microsoft.com/t5/Developer/Project-Online/m-p/3726165#M49802 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/695347">@Pankhuri_16</a>&nbsp;,</P> <P>&nbsp;</P> <P>Adding custom date columns in Project Online requires setting up the use of custom fields through the Project Web App (PWA)</P> <P><A href="https://learn.microsoft.com/en-us/project-for-the-web/add-custom-column-project-power-app#add-a-custom-column-using-the-power-app-portal" target="_blank">Add a custom column to the Project Power App - Project for the web | Microsoft Learn</A></P> <P>&nbsp;</P> <P>If you want to add a new date column in Power BI after importing Project Online data, you can check the following:</P> <P>Create custom columns in the Power Query editor:</P> <P><A href="https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview" target="_blank">Query overview in Power BI Desktop - Power BI | Microsoft Learn</A></P> <P><A href="https://learn.microsoft.com/en-us/power-query/add-custom-column" target="_blank">Add a custom column - Power Query | Microsoft Learn</A></P> <P>Use the Dax function to create custom columns:</P> <P><A href="https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns" target="_blank">Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn</A></P> <P>Refer to:</P> <P><A href="https://community.fabric.microsoft.com/t5/Desktop/Create-a-custom-column-with-a-new-date-based-off-another-s/m-p/946070#:~:text=1.%20Add%20Column%20-%3E%20Custom%20Column.%202.%20Type,get%20a%20custom%20column%20that%20meets%20your%20requirements." target="_blank">Solved: Create a custom column with a new date based off a... - Microsoft Fabric Community</A></P> <P><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-project-online-connect-to-data" target="_blank">Project Online: connect to data through Power BI Desktop - Power BI | Microsoft Learn</A></P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly.</P> Tue, 27 Feb 2024 05:59:42 GMT https://community.fabric.microsoft.com/t5/Developer/Project-Online/m-p/3726165#M49802 Anonymous 2024-02-27T05:59:42Z