Data View - Transform Data

Question

Hi all,&nbsp;Relatively new to Power Bi here, I just have a quick question about the data view. I have created a DATEDIFF column in the data view to look at the difference in days between when a requisition has been approved and when it has been closed in our company's Applicant Tracking System.&nbsp;&nbsp;Upon creating this column which displays the difference in days, I would also like to create a conditional column to essentially flag if a requsition has been opened and closed within the space of 5 days (If Req Approved - Req Filled&nbsp;≤ 5, Yes, No),&nbsp;however I noticed that any column you create in the data view is not visible once you go to Transform Data. I refreshed the data set multiple times and the DATEDIFF column still doesn't appear when I go to transform data.&nbsp;Could anybody please help me understand why that is? &nbsp;Many thanks,Alex

freemanz · Answer

hi&nbsp;Anonymous&nbsp;After you click Transform Data, it leads you to Power Query Editor. The columns you added with DATEDIFF is not supposed to reflect in the Power Query Editor.You can add custom columns in Power Query Editor instead.https://learn.microsoft.com/en-us/power-query/add-conditional-column&nbsp;

anonymous · Answer

Thank you for your reply! What would be the best way to create a custom column that gives me the difference in days between two dates in Power Query in this case?&nbsp;&nbsp;Alex

Forum Discussion

Data View - Transform Data

2 Replies

Related content

Data transform using power query

Eventhouse data transformation

Data Transformations

After transformed data, inside Table View the col go to the end

Table Transformation