Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

0
AlexDantin

localnow() M function is different in PowerBI than is documented

Submitted by Helper I on ‎12-09-2016 06:43 AM

https://msdn.microsoft.com/en-us/library/mt253492.aspx

 

Per this site, the M function should return

DateTime.LocalNow()equals 2013-03-08T14:22:42

in that format - but in PowerBI Query Editor, the month and day are returning single digit values for 1-9. This makes it very difficult to create functions that rely on aligning a datekey to an existing table based on the current date when refreshing.

Status: Delivered
See more ideas labeled with:
5 Comments (5 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎12-11-2016 11:36 PM

@AlexDantin

 

This is not related to Power BI but Power Query itself. If we use Query Editor in Excel, we will get the same result as below.

 

localnow() M function is different in PowerBI than is documented_1.jpg 

 

Best Regards,

Herbert

AlexDantin
Helper I
Helper I
‎12-12-2016 04:49 AM

Thank you for the clarification.

Vicky_Song
Impactful Individual
Impactful Individual
‎12-12-2016 10:03 PM
Status changed to: Delivered
 
AlexDantin
Helper I
Helper I
‎12-13-2016 04:50 AM

What does Delivered mean? Has this problem been delivered to the Power Query Team?

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎12-13-2016 08:35 PM

@AlexDantin

 

Since it is not related to Power BI but Power Query, you need to post this problem in Power Query forum.

 

Best Regards,

Herbert

Idea Statuses