Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@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")
@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")
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
20 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |