cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Isaac-cordova Frequent Visitor
Frequent Visitor

Custom Column that can record the CREATED DATE OF EXCEL SURVEY LINE ITEM

 

Hello Experts,

 

I have created a EXCEL ONLINE SURVEY with 2 questions (NPS typical Q.)  and used it as data-source for my NPS PBI report.

 

WITHIN PBI DESKTOP I need to create a TIMELINE FOR  the  CREATION-DATE of the Responses.

 

Q: What is the best approach to get the date-created recorded please?

 

Kind Regards

Isaac

3 REPLIES 3
Super User
Super User

Re: Custom Column that can record the CREATED DATE OF EXCEL SURVEY LINE ITEM

This is tough. I don't think there is a feature in Excel surveys to create a time stamp automatically. You could ask it as a question, but I guess it would be subject to error. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Moderator v-sihou-msft
Moderator

Re: Custom Column that can record the CREATED DATE OF EXCEL SURVEY LINE ITEM

@Isaac-cordova

 

Power BI dekstop is just a design tool for rendering the data from the data source. In this scenario, those date-creation time should be recorded in your data source which is EXCEL ONLINE SURVEY. If it doesn't log the date-creation time, you can do nothing in Power BI Desktop.

 

Regards,

Isaac-cordova Frequent Visitor
Frequent Visitor

Re: Custom Column that can record the CREATED DATE OF EXCEL SURVEY LINE ITEM

Thank you for replying.  you are right, I will have to find out a way in EXCEL ONLINE SURVEY to get the Today´s Date.

I do not desire to prompt the respondents to fill in the "Date" for me. they will drop the survey.

 

- Unfortunately EXCEL ONLINE SURVEY does not offer  such thing as  default a Field To  " =TODAY()"

 

So I will have to take my question  to  a EXCEL ONLINE SURVEY Forum

 

Thank you and thanks to

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 356 members 3,554 guests
Please welcome our newest community members: