cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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,

Highlighted
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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 362 members 3,862 guests
Please welcome our newest community members: