Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Elie_HUCHET
Helper II
Helper II

power query-VBA code problem

Hello,
I have a very special problem. I created a macro in Excel that works. The latter is used to know the date of entry of information and that the cell is fixed. I wanted to put on macro on Excel but in a Teams group. Unfortunately, this macro does not work because it is not VBA language but DAX on Teams! Therefore, I would like to know if someone can make a macro in DAX allowing to have the date and time of entry of the information

This is the macro:

 

Private Sub Worksheet_Change(ByVal Target As Range)

Dim j, iSct As Range

Set iSct = Intersect(Target, Range("A:A"))
If iSct Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each j In iSct.Cells
If IsEmpty(j) Then
j.Offset(0, 3) = ""
Else
j.Offset(0, 3) = Format(Now, "mm/dd/yy hh:mm:ss")
End If
Next
Application.EnableEvents = True


End Sub

As you can see I would like the date and time entered in column A to appear in column C.

Thanks for your help

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Elie_HUCHET , we can not create macro in DAX, we can create new column in Power Query or DAX as per need

 

example

New column = Format(Now() , "mm/dd/yy hh:mm:ss")

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Elie_HUCHET , we can not create macro in DAX, we can create new column in Power Query or DAX as per need

 

example

New column = Format(Now() , "mm/dd/yy hh:mm:ss")

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors